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!