How to highlight duplicate entries?

[Guest]

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!

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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!

 

[Guest]

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:

 

[Guest]

in D3 (Assuming that is the 2nd row of data in your list, acoounting for a
title row), type:
=IF(A3=A2,"Y","N")

This will palce a y in the D Col next to any repeating values in the A column.

Hope this helps.