Variable Drop Down Menu / Data Validation (DV) List

Objective

In a model you need multiple drop down menus, the choice in drop down menus is dependent upon each other. Like if ones chooses Asia (in 1st menu), then only Asian Countries be available as second choice (2^nd menu); for Europe only European countries be prompted.

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)

Key Advanced Skill: Creating List from scattered entries by Avoiding/Ignoring/Skipping empty rows

Objective

You are working on a data set and want to get your results based upon certain criteria.  Now the problem is your result contains blank rows / rows which do not qualify with your criteria. You want result as a list i.e. without blank rows. 

This model/method resolve many data picking/filtration issues,therefore in my opinion its a KEY concept.

INDIRECT Function (Basics)

Objective

Understanding & using INDIRECT Function.

VLOOKUP Multiple Occurrence

Objective

Many a times, while searching a list, the searched text/value may appear more than once. Standard VLOOKUP will return first occurrence from top. The question is how to find second, third or fourth occurrence?