MrExcel Publishing
Your One Stop for Excel Tips & Solutions

duplicate entries

Posted by pryan on July 18, 2001 8:35 AM

Importing info with many duplicate phone numbers for broadcast fax. Need a way to eliminate the dupes. Any suggestions?


Posted by Barrie Davidson on July 18, 2001 8:58 AM

Sort your data and then, from the main menu, select Data|Filter|Advanced Filter. Select "Copy to another location", "Unique records only", and input your new location in the box titled "Copy to". You now have a data set with no duplicates.

NOTE - this will only work for data that contains a header in the first row.