MS Excel Secrets - Filtering Unique Records

Sometimes,you have a list of items in Excel that I would like to filter through the data to get rid of the duplicates.  

One way to find only unique records is to use the “Remove Duplicates” feature. 
 
If you are in Excel 2007, you can do this by clicking on the Data tab and then choose the “Remove Duplicates” button.

Read lots more MS Excel Secrets



You will be given a list of the columns in your Excel sheet. Select the columns you would like to search in to find the unique records. Then click OK. 

Make sure that you click the “My Data Has Headers” check-box if your have column headings, so that they do not get filtered, too.

Related Posts:
How to Convert PowerPoint to Flash Flipbook