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


MS Excel 5002574629396906250

Post a Comment

SPAMMING will not be Appreciated.


Hot in week



Our Channel

Contact Us


Email *

Message *

Follow by Email