| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using "=randbetween" to select a number from a range of cells
I've just begun using =randbetween, bear with me!
I am trying to come up with a random number from a set of about 100 cells. The only numbers available in those 100 cells are 0 thru 4. Do I set my function to choose a random number between 0 and 4 (=randbetween(0,4)) or do I set it to pick a random number from the range of cells (=randbetween(A1:A100))? Is there going to be any difference in the data I come up with? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Range("cell").Select Problem | Excel Discussion (Misc queries) | |||
| range("a1").select not working | Excel Discussion (Misc queries) | |||
Threaded Mode
