Dedupe Records in Excel 2007

Many of us deal with very large lists in Excel, such as large mailing lists. Excel 2007 has several new features that make it well worth its cost in mail list management. First of all, it is now able to open spreadsheets that have up to 1 million rows and 16,000 columns (give or take). This is an enormous leap over approx. 64,000 rows in Excel 2003. Secondly, it has a built-in DeDuping feature, that can save you hours of time and hundreds of dollars in 3rd party software or services. This article is going to show how to use the new DeDuping feature in Excel 2007.

Steps

  1. Click on any cell in the spreadsheet.
  2. Click the Data tab on the Ribbon.
  3. Click on the Remove Duplicates option.
    • Doing so will select all the data in the database and open the Remove Duplicates dialog box.
    • When the dialog box opens, all of the column headings are selected by default.
    • To remove only those records from the database that match another record exactly:
      • Leave all column headings selected and Click OK.
    • To remove records from the database that have duplicate data in only one or more columns:
      • Remove the check marks from those columns you do not want to compare.
  4. Click OK



Tips

  • If you remove the wrong data, click the Undo button on the Quick Access toolbar or press CTRL + Z on the keyboard to get your data back.
  • Of course if you are just learning this tool, it is always safest to work with a COPY of your ORIGINAL spreadsheet!

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Dedupe_Records_in_Excel_2007&oldid=353020"