Excel: Generate a Unique List (get rid of Duplicates) – Method #1
You have a list of entries listed down a column – a number of which are duplicate/triplicate/etc entries. You’d like the list cleaned up so that you have only ONE of each entry option.
Use the REMOVE DUPLICATES feature.
Full tip: Excel tip