Array (Excel Function - Conceptual)

Objective

Array is a very powerful tool that can enhance power of normal excel functions manifold. Arrays are also used in VBA to store and retrieve data.

Most of the times, my audience is non-IT people, who are not familiar with Array concept. So here it is in layman language.

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.

VLOOKUP Search in middle or right column & get result from left side column(s)

Objective

VLOOKUP always search in left column and get result from right side. How to make VLOOKUP search in right column and get result from left column.

INDIRECT Function (Basics)

Objective

Understanding & using INDIRECT Function.