Tuesday, April 5, 2011

yogi_Selecting Item Randomly From Filtered List


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

ahs004 said:
I want to select a name from a list in a column after filtering the data using other columns
-------------------------------------------------------------
Let us assume the filtered list is as shown in the following illustration in column A. I use the RAND function to generate a random number assuting that there is a potential to generate a positive integer with a value varying from 1 to the total number of items in the filtered list.

So here we go ...