| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random number from a list
I have to generate a random number from a specific list of Numbers, eg:
List 1 List 2 List 3 List 4 2001 2063 2069 2755 3552 2587 2954 3664 3554 3444 5441 4441 3541 4841 3647 the list goes on for some 2000 lines I cant use Randbetween, because that would produce a number that may not be in the the specific list. I need to produce 4 numbers at random from each list, You'll notice that there may be spaces in the table, these spaces contain an if formula that has been """". Does anyone know how this can be overcome possibly by using vb code |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| generating random number list | Excel Worksheet Functions | |||
| extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
| Generate random number from a list | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Threaded Mode
