hi

take a look at Chip Person tips at

http://www.cpearson.com/excel/duplicat.htm#Replacing

hth
regards from Brazil
May the force be with you
Marcelo
*******************


"Kimbor" escreveu:

Howdy! I have a large, but simple, database list consisting of three columns
-- first name, last name, email -- that I've sorted by last name. I'm
looking for a formula that will find the duplicates and highlight them for
me. It sounds simple, but I just can't figure it out. Anyone? Thanks!