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)

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.

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.