Thread: [Solved] Searching for Dupes
View Single Post
 
Old 03-02-2015, 06:47 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

* 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.
Reply With Quote