Search for DUplicates

Ken · Oct 13, 2003

I have excel spreadsheet that has 3000 names in one column . Is there a way
to have it search for duplicates and move the duplicates to another sheet ?

Thanks
Ken

J.E. McGimpsey · Oct 13, 2003

Take a look at

http://cpearson.com/excel/duplicat.htm

Ken · Oct 13, 2003

Exactly What I wanted
Thank you very Much

J.E. McGimpsey said:
Take a look at

http://cpearson.com/excel/duplicat.htm