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

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!