| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random cell selection from a column of cells
This seems like it should be easy.
How do I make a random cell selection from a column of cells? Regards, MF |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random cell selection from a column of cells
To pick at random from A1 thru A100:
=OFFSET($A$1,randbetween(0,99),0) -- Gary''s Student - gsnu200839 "MF" wrote: This seems like it should be easy. How do I make a random cell selection from a column of cells? Regards, MF |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random cell selection from a column of cells
Hi,
If the cells are in the range A1:A100: =OFFSET(A1,RAND()*100,) If there are more or less rows you can change the 100 portion. The down side is this formula will be returning cell A1 sometimes, which may not be best if you have a title there or you data starts on a row other than 1. In that case, for example if your cells run from A5:A105 then use =OFFSET(A1,5+RAND()*100,) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MF" wrote: This seems like it should be easy. How do I make a random cell selection from a column of cells? Regards, MF |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I sort a selection of cells into random order? | Excel Discussion (Misc queries) | |||
| Random selection of text cells | Excel Discussion (Misc queries) | |||
| "Random selection between two cells" | Excel Discussion (Misc queries) | |||
| random selection from a range of cells | Excel Worksheet Functions | |||
| How can I set up the random selection of a cell from within a ran. | Excel Discussion (Misc queries) | |||
Hybrid Mode
