Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a random cell < 1
I'm not a programmer so I'm struggling with this.
I have a dynamic range of cells (say A1:A600, but will expand beyond A600). These cells get individually populated over time with a 1. I'd like a routine to identify all cells in the range *without* a 1, and then from this collection, choose a random cell (or row #, since it's all in col. A). Any sample code would be appreciated. Thanks. Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select other random cells | Excel Worksheet Functions | |||
Random select of text | Excel Worksheet Functions | |||
Select a random sample | Excel Discussion (Misc queries) | |||
Random select entries | Excel Discussion (Misc queries) | |||
Select random cell | Excel Worksheet Functions |