MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to Filter Out Duplicate Data


February 17, 2002 - by Juan Pablo Gonzalez

Paul asks:

Please help! I work closely with comparative lists and need to learn how to either identify duplicate cells or even better filter out duplicates. Can you help?

Sure, just select the range where the duplicates are. Go to data, Advanced Filter, select "Copy to new location", leave the "Critiera" field empty, and make sure you have chekced "Unique Entries Only".