![]() |
#1
|
|||
|
|||
![]()
Hello all,
I am looking for help with this vba problem i have. I have a system that accepts 3 types of demand in bulk. Each bulk has quantities in it. I have been able to split this quantities randomly from 1 to 5 splits before going into the system sequencially. But now i want these splits to go in a random sequence with no same type following each other. For example Type 1: 5 quantities; splitted into 2,3 Type 2: 7 quantities; splitted into 3,4 Type 3: 6 quantities; splitted into 1,1,1,1,2 And they go into the system in that sequence: 2,3,3,4,1,1,1,1,2 But i want to sequence to be random with no two of the same type following each other. Please how can I achieve this with code. Thanks |
Tags |
random sequence, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Random with Kurtosis | ramesh31 | Excel | 0 | 02-18-2016 03:45 AM |
Sequencing duplicates | balajigade | Excel Programming | 3 | 10-04-2015 03:31 PM |
![]() |
knp11 | Word | 1 | 01-18-2015 11:41 AM |
Random indentation | Galahad | Word | 1 | 09-25-2013 11:05 AM |
random pop up wont go away | 464646 | OneNote | 0 | 05-01-2012 04:34 AM |