| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomly selecting a cell weighted on percentage
Disregard the earlier which was wrong. Sorry ..
Formula in A5 should read as: =INDEX($A$1:$D$1,MATCH(RAND(),$A$3:$D$3,1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting randomly specific value in a list | Excel Worksheet Functions | |||
| Selecting Data in a Table With percentage limits | Excel Discussion (Misc queries) | |||
| Selecting the value from a randomly selected cell out of a range | Excel Discussion (Misc queries) | |||
| Selecting Data From a Table With percentage limits | Excel Discussion (Misc queries) | |||
| Selecting at random with weighted probability | Excel Worksheet Functions | |||
Threaded Mode
