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.
1. The Remove Duplicates Button on the Data Tab
Firstly, 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.
2. The UNIQUE Function
The 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.
3. Power Query
Power 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
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.