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


If you want the address of a randomly selected cell from some column, say, B, try:


Hope this helps.


Posted by Mark W. on July 17, 2001 7:13 AM