How to highlight duplicate entries?

K

Kimbor

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

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

Wiley

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.
 
Top