How do I randomly select cells regardless of cell content?
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.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"gmadden2" wrote:
I'm attempting to unconditonally and randomly select cells in a spreadsheet
|