How to highlight duplicate entries?
 

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!

How to highlight duplicate entries?
 

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kimbor" wrote in message ...
| 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!

How to highlight duplicate entries?
 

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!

How to highlight duplicate entries?
 

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.

"Kimbor" wrote:

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!