Extract Random Variables from Excel

[Craig Carden]

I need excel to extract random variables from a
spreadsheet based on several different columns. I need
random rows that have specific data in each column pulled
from the spreadsheet based on one or more of the specific
data in each column. For example, each row is a group of
meter routes and I want to randomly select one meter from
several different routes based on different critieria
such as age, usage, and location. Please respond if
anyone can assist me with a formula to operate this.
Thanks. Craig

 

[Jonathan Rynd]

I need excel to extract random variables from a
spreadsheet based on several different columns. I need
random rows that have specific data in each column pulled
from the spreadsheet based on one or more of the specific
data in each column. For example, each row is a group of
meter routes and I want to randomly select one meter from
several different routes based on different critieria
such as age, usage, and location. Please respond if
anyone can assist me with a formula to operate this.

What do you mean by "extract"? Once you select a row, what do you want to
do with it?

Are you using VB or worksheet functions?