| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomly selecting a cell weighted on percentage
Errata (wrong source sheetname used earlier):
In A2 should be: =IF(COLUMN()COUNT($1:$1),"",INDEX(Sheet1!1:1,MATC H(SMALL($1:$1,COLUMN()),$1:$1,0))) -- 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
