View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default How do I locate duplicate records in Excel?

Check out Chip Pearson's web site:

http://www.cpearson.com/excel/topic.htm

Scroll down to the D's, and see all the pages on handling duplicates.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Amie G" wrote in message
...
I'm trying to locate duplicate records in my spreadsheet. It has 15

columns
and almost 3000 rows. Row B is Last Name and Row C is First Name. I need

to
highlight any records that have the same last and first names. So if

there
are multiple Bob Jones I want to check and see if they are the same

person.

How do I do this? I've tried all kinds of methods suggested on the web

and
have not been able to find a solution. Thanks!