Hi

Check out Chip Pearson's page on working with duplicates at
http://www.cpearson.com/excel/duplicat.htm

the article you're after is right down the bottom of the page, but you also
might find some other useful things along the way.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"dannix54" wrote in message
...
I have two worksheets; One with the names (last, first) of last years
employees,
The second with the current employee list (last, first). I need to compare
the two lists and display a list of employees NOT on the current list.
"who's
not with us anymore". Can anyone help? Thanks.