First sort your data by last name, then by first name

Highlight all rows | Data | Sort | First by Column B | Then by Column C

Now your list is in alphabetical order by last name.

Highlight all 15 columns | Data | Filter | Advanced Filter | Copy to new
location | Copy to: (click on the little icon and click on the first row in
the first empty column to the right of the data | Check the box that says
Unique Records Only | Ok | Delete the old data, the new "copied" data will
not contain duplicates.

Pamela :)

"Amie G" wrote:

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!