Tip #165_Excel

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