Translate

Sunday, April 30, 2017

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 (2nd menu); for Europe only European countries be prompted.

Saturday, April 29, 2017

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.

Thursday, April 13, 2017

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)


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.