Select random cell from a range
Posted by Alastair Robertson on July 17, 2001 3:07 AM
How should I select a random cell from a column.
I have tried something along the lines of:
in cell A10 creating a random number * 10 and round to nearest whole number.
Then creating a formula =(A(A10)) but I can't get it to work. Any ideas?
Posted by Aladin Akyurek on July 17, 2001 3:58 AM
Alastair,
If you want the address of a randomly selected cell from some column, say, B, try:
=ADDRESS(INT(RAND()*100),COLUMN(B:B))
Hope this helps.
Aladin
Posted by Mark W. on July 17, 2001 7:13 AM
Try...
=INDIRECT("A"&INT(RAND()*(10-1)+1))
