Remove Duplicates in Excel

You are here:
< Back

*Video is old, but the information is still relevant and correct

How to Remove Duplicates in your Excel file (for reporting or general clean-up)

Sort your data so that the row you want to keep is above the duplicate rows. Next go to the Data ribbon and click the Remove Duplicates option. It will ask you which fields you would like to use to define what creates a duplicate value. If you are trying to remove duplicate contacts, the ContactIPK field is your best option to leave you with one record for each contact record in DonorSnap. Click Ok and Excel has removed all of the duplicate rows.

Here’s a video that will show you in Excel 2013:

Tags:
Table of Contents