How do I randomly select cells regardless of cell content?

[gmadden2]

I'm attempting to unconditonally and randomly select cells in a spreadsheet

 

[Luke M]

If you mean randomly find the value of a cell,
=INDEX(1:65536,INT(RAND()*65536),INT(RAND()*256))
Every time a calculation is performed, this will randomly pick a different
cell in the spreadsheet.

If you want an actual selection, you'll have to use VBA. If we knew more
about the goal/purpose, might be able to provide additional help.

 

[Bernard Liengme]

To randomly select a cell from the range A110, use
=INDEX(A110,RANDBETWEEN(1,10),RANDBETWEEN(1,4))

RANDBETWEEN need the Analysis Toolpac (except in XL2007), or you could use
best wishes

 

[Shane Devenshire]

Hi,

Careful with
=INDEX(1:65536,INT(RAND()*65536),INT(RAND()*256))

RAND generates a random number between 0 and 1. Suppose the result is
<=0.00001
INDEX(1:65536,0,0) is #VALUE!

Instead
=INDEX(1:65536,INT(RAND()*65535+1),INT(RAND()*255+1))