Tip #165_Excel

Excel: Generate a Unique List (get rid of Duplicates) – Method #1

 

Scenario:

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.

 

Solution:

Use the REMOVE DUPLICATES feature.

 

Full tip: Excel tip