* Select the table of your data including headers, if any.
* Select Data>Remove Duplicates.
* If you have headers, check "My data has headers" and the headers will be displayed in the list (rather than just the column letters.
* Uncheck all but the columns you want to check for duplicates i.e. make sure just first and last name are checked.
* Press OK.
|