User login
InsideSales.com Free Trial
How to dedupe a list of phone numbers on an Excel spreadsheet.
Wed, 02/04/2009 - 18:53
1. Sort the list by phone ascending
2. Create a blank column to the right of the phone column
3. Use the formula “=if(A3=A2,1,””). However make sure the cell addresses (A2,A3) in the formula match the actual phone fields.
4. You’ll search for all the cells marked with a “1” and delete them as they are the duplicates. Or you may want to cut and paste to another spreadsheet so you have a record of them.
