Duplicate Name Rows

[mmednick]

I have a spreadsheet with 4 collumns:
First Name, Last Name, Dept, and Mailing Address.

There are duplicate rows of peoples names which I need deleted, but all
the steps I have found online only sort on one collumn. Assuming I am
sorting by Last Name, they will delete not only the extra rows of a
specific person's name, but also other people (which would be terrible)
whom have the same last name with a different first name if that makes
sense.

Does anyone have an idea for how I can delete the rows of deplicate
people?
Filter, Macro, etc?

 

[Niek Otten]

Concatenate two or three columns in a new one, perform your deletions based
on that column and delete the now superfluous column

Please do this all on a copy of your workbook!