comparing list of names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I was given the task of updating personnel records and need to compare the current records with the previous years. I need to show the names that are not on the current years. Essentially, comparing 2004 personnel records against 2003 records and showing the difference in names.
I have tried using match and vlookup and have not any success. I usually keep coming up with a cirucular reference error.
I would greatly appreciate any insight that anbody could give.
Thanks for your help

2003 Records 2004 Records Show that
Abbot, John Abbot, John Karen, Kat and Stump, George are no longer
Cook, Sam Cook, Sam in the 2004 records
Kat, Karen
Mud, Tom Mud, Tom
Stump, George
 
Hi cjs
If your original data is in Column A and new data in
column B, you could put in column C
=IF(A2=A1,"OK","not listed")
Obviously, the data would have to be in adjacent columns.
Otherwise, a VLOOKUP would work but you would need a
unique identifier for each record, a simple number system
would do.....1,2,3,4 for each record.

Regards
Michael
-----Original Message-----
Hello
I was given the task of updating personnel records and
Click to expand...
need to compare the current records with the previous
years. I need to show the names that are not on the
current years. Essentially, comparing 2004 personnel
records against 2003 records and showing the difference in
names.
I have tried using match and vlookup and have not any
Click to expand...
success. I usually keep coming up with a cirucular
reference error.
 
Hi cjs!

Here's one way:

2003 records in A2:??
2004 records in B2:??

In C2, enter this formula and copy down as needed to equal
the range length of the records in col A:

=IF(COUNTIF(B$2:B$100,A2)=0,A2,"")

Biff
-----Original Message-----
Hello
I was given the task of updating personnel records and
Click to expand...
need to compare the current records with the previous
years. I need to show the names that are not on the
current years. Essentially, comparing 2004 personnel
records against 2003 records and showing the difference in
names.
I have tried using match and vlookup and have not any
Click to expand...
success. I usually keep coming up with a cirucular
reference error.
 
Back
Top