How to Remove Duplicates Using Advance Filter?

Data before removing duplicates.

Data after removing duplicates.

Let us follow step by step process for removing duplicates using Advanced Filter.

Select a cell in your data set and choose Data from menu.

Select Filter and select Advanced from Sort and Filter group.

Advanced Filter dialogue box appears.

Enter the range of data containing duplicates in the box provided for List range.

Here the List range is ‘$B$3:$C$16’.

Check the box Unique Records Only and click OK.

advanced filtering in excel

Excel removes duplicates and provide you a unique list of records.

————————————————————————————————————–

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.

Comments (1) | Trackbacks (0)