finding missing data between two worksheets
Did you enter this on Sheet 1?
If all cells in B are same as A then it means that all values in Sheet 1 Col
A are present in Sheet 2 Col A
If that is the case then try the reverse
Enter in B1 of Sheet 2 and copy down
=VLOOKUP(A1,Sheet1!A:A,1,False)
"Mossykel" wrote:
Didn't work. Entered the exact formula and all I get in column B when
copying down is the first value in A1...
--
KM
"Sheeloo" wrote:
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
|