Hey,
Say if I have two lists of names, one in sheet 1 and one in sheet 2. I want to check who isn't on sheet 1 from sheet 2, and then put this set of people (not found in sheet 1) onto sheet 3. Am sure there will be a way to do this, but I can't figure it out! Need some of you excel gurus to give me a hand!
Thanks in advance,
Nick
In Sheet2...
=Isnumber(Match(A1,Sheet1!A:A,0))
where A1 is first name in Sheet2 and Sheet1 names are in column A
copied down.
This will give TRUE if the name is found and FALSE if not.
Then in Sheet2, go to Data|Filter|Autofilter and filter the data for FALSE.
Copy and Paste that over to Sheet3.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks