finding missing data between two worksheets
If you have both lists in Col A of Sheet1 and Sheet2 respectively, then in B1
of Sheet1 enter
=VLOOKUP(A1,Sheet2!A:A,1,False) and copy down.
Filter on Col B on #N/A... these will be the missing from Sheet2, Col A
"Mossykel" wrote:
I have a master list of people and their ID number in worksheet 1. I'm
trying to find the missing individuals from what I have in worksheet 2 and
put them in a new worksheet 3. Please tell me the easiest way to do this...
Thank you,
--
KM
|