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