Translate

Showing posts with label Function. Show all posts
Showing posts with label Function. Show all posts

Monday, April 3, 2017

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.

Monday, February 20, 2017

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?