Chip has lots of stuff on duplicates and comparing worksheets
see www.cpearson.com


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"EMCUE" wrote in
message ...

1) I have a contact list for previous conference years. 1999-2006. I
want to find all the duplicates and have the duplicates pulled onto
either another worksheet or an area on the same worksheet.

2) I had to previously pull a random sample of potential duplicates for
another database import. I had about 350 random numbers from a
population of 3900, and then found those contacts associated with the
random numbers. This list was in alpha order. In the future is there a
way to extract the contacts associated with the random number set, such
that I do not have to manual deleted contacts?

Future Thanks!

Again, I love this forum! :) :) :) ;) :)


--
EMCUE
------------------------------------------------------------------------
EMCUE's Profile:
http://www.excelforum.com/member.php...o&userid=32945
View this thread: http://www.excelforum.com/showthread...hreadid=552852