Tip #185_Excel

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

 

Scenario:

You have a list of entries listed down a column – several of which are duplicate/triplicate/etc. entries. You’d like the list cleaned up so that you have only ONE of each entry option.

 

Example:

In our list, each employees record depicts their manager’s name. You’d like to create a drop-down for the Manager column – but that entails have a list of unique names.

 

Solution:

We can make the list of unique names from the existing column of duplicate names.

 

Full tip: Excel tip