Removing Duplicates in Excel Using Advanced Filter

• Select the entire table from where you want to remove duplicates.
• Now sort the table with the column for which you want to compare for duplicate entries.
• Select the entire table again and click on advanced filter.
• Select radio button "Copy to another location".
• List range will automatically populate according to your selection.
• Place the cursor on the copy to; and select a cell where you want unique entries to come.
• Now select the check box "Unique records only" and then press ok.