http://mcgimpsey.com/excel/conditional6.html


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"HERNAN" escreveu:

After I locate the duplicate how do I sort them?? I want to delete them. And
I have more than 4,000 names?
Thank you!! Obrigado!


"Marcelo" wrote:

http://www.j-walk.com/ss/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"HERNAN" escreveu:

I have 2 columns with text

A B
1 John Kim Susan Douglas
2 Susan Douglas Mary Barry
3 Martin Smith Mike Miguens

I want to locate and be able to sort the duplicates cells in column A (ie:
A2 ) so I can delete them later.
THANK YOU!!!!!!!!