| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random entry from list
Anyone know how to insert a random entry into a cell that is drawn from a
list or range of cells? For example, if I have AA,AB,AC,AD,AE,AF in A1:A6 and in A7 I wanted it to give me randomly one of the values from the range. Cheers, Job |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
| How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
| How do I get Excel to select a random entry for me? | Excel Discussion (Misc queries) | |||
| random number entry based on two criteria | Excel Discussion (Misc queries) | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Threaded Mode
