If you have a list of items and want to remove any duplicate entries in the list, here are three great ways to go about it.

Watch on YouTube & Subscribe to our Channel1. The Remove Duplicates Button on the Data TabFirstly, if you go to the Data tab on the Ribbon, there's a button called Remove Duplicates.

With any cell selected in the column that you want to remove duplicates from, just hit the button. Then you'll get a Remove Duplicates popup window to verify which columns you want to change. Verify your selection and hit OK.

If you want to keep the original list, make a copy before removing the duplicates.

1. The UNIQUE FunctionThe UNIQUE function has options to de-duplicate columns OR rows. Also, it has the ability to return values that only appear once in the list.

You can even use the UNIQUE Formula for Non-Adjacent Columns.

1. Power QueryPower Query has the ability to remove duplicates in one or more columns.

If you're not familiar with Power Query, it's a powerful data automation tool, and it's great to use for importing data into Excel and cleaning it up. You can learn more about Power Query at this tutorial: Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool

Other Methods?So, how do you de-dupe? Leave a comment if there are other techniques that I missed.

Hope this was helpful! See you again next time.

Link to post: 3 Ways to Remove Duplicates