TIP - 44 : Advanced filter in excel

Advanced filter in excel – unique records only

This feature is very helpful to get the unique records out of the total list of records and used to get the criteria-based records as well.

Step 1: Click on Advanced filter from Data Tab

Step 2: From the dialogue box Advanced filter, choose “copy to another location” (it is always better to choose new location)

Step 3: Select list range from your data base or table, criteria range keep it as blank and copy to select the cells where you want to place your data

Step 4: Click on check box “Unique records only”, Then click on OK

Only unique records will be published.

When you want a criteria-based, just use criteria range and select data as shown below –

So you can filter data records based on conditions aswell.