| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to randomly select from a list with condition
I have a list of twenty real number in A1 to A20. How can I randomly select a number from the list, but not the one with value = 0 If the selected number is zero, it will automatically select another random number from the list. The list is dynamic, so I don't know exactly when and where the ones with zero value show up. Thank you. Katherine. -- kathyxyz ------------------------------------------------------------------------ kathyxyz's Profile: http://www.excelforum.com/member.php...o&userid=25624 View this thread: http://www.excelforum.com/showthread...hreadid=390385 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Select Multiple entries from Valid list for a Cell | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| subtotaling and manipulating a list of data | Excel Worksheet Functions | |||
| List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
| select unique to make list | Excel Worksheet Functions | |||
Threaded Mode
