Q qwibble Jan 27, 2010 #1 I am looking for a way to randomly select lines from a list of items for work. Is there a way to perform this function in excel?
I am looking for a way to randomly select lines from a list of items for work. Is there a way to perform this function in excel?
L Luke M Jan 27, 2010 #2 Lets say you have a list of 15 items. =INDEX(A1:A15,RANDBETWEEN(1,15)) Pressing F9 will generate a new random value from your list. Note that RANDBETWEEN requires the Analysis ToolPak add-in.
Lets say you have a list of 15 items. =INDEX(A1:A15,RANDBETWEEN(1,15)) Pressing F9 will generate a new random value from your list. Note that RANDBETWEEN requires the Analysis ToolPak add-in.
