MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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))