I have a list of 16 names. I need to create a random list of 6 names, three of which are either the 8th or 9th name and both the 8th and 9th name have to appear in the random list. The remaining three names must be from 1 through 7 and 10 through 16, and at least 3 of the names must be from 1 through 8. It would also be better (but not mandatory) if numbers were only chosen once.
Create random list with multiple criteria
- Thread starter bctyner
- Start date
Hello Faseeh,
Thank you for the help. It works well, however sometimes the first list pulls all 8s or all 9s, and sometimes the second list pulls all numbers between 1 and 7, and other times all between 10 and 16.
Essentially I need one list to calculate three numbers between 8 & 9, and another formula to pull three numbers from 1 and 7 and 10 and 16. The second list, though, must pull two numbers between 1 & 7 if there is only one 8 in the first list. If there are two 8s, then the second list should pull two numbers between 10 & 16.
Also, each number in the second list should be unique (i.e., no duplicates).
I hope this helps clarify, and thanks again for the help!
Best,
Bryan
Thank you for the help. It works well, however sometimes the first list pulls all 8s or all 9s, and sometimes the second list pulls all numbers between 1 and 7, and other times all between 10 and 16.
Essentially I need one list to calculate three numbers between 8 & 9, and another formula to pull three numbers from 1 and 7 and 10 and 16. The second list, though, must pull two numbers between 1 & 7 if there is only one 8 in the first list. If there are two 8s, then the second list should pull two numbers between 10 & 16.
Also, each number in the second list should be unique (i.e., no duplicates).
I hope this helps clarify, and thanks again for the help!
Best,
Bryan