• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want to compare two separate user sheets

outlaw

New Member
Monthly, I have to compare lists of inactive users about to be disabled. Unfortunately, creation of each months new list overlaps the previous months disablement process. I would like to be able to compare, for example, the March sheet against the April sheet and produce a result of just those that are not on both sheets. Any help will be greatly appreciated!
 
On each sheet:

=COUNTIF(Other_Sheet_List,A2)=0


All the TRUE's are names that are not on the other list.
 
Back
Top