Drop Down Menu in Cell / Data Validation List

Objective

You need a Drop Down menu linked with a cell, that will show choices to user to Select, instead of typing.

This is useful when there are limited number of options to choose from.

6 Ways: Unique List of items from Multiple entries

Objective

You have some data where a particular field has many items occurring repeatedly and you need a list of unique items only like from (A,B,A,C,D,E,F,F,E,C,B,A,D) you need (A,B,C,D,E)