J
Janet
I have divided 36 numbers (1-9) into groups of 4. I need to randomly pick 1
number from each group. How do I do that?
number from each group. How do I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Use Index() with Randbetween()
J
Janet
Janet said:I have divided 36 numbers (1-9) into groups of 4. I need to randomly pick 1
number from each group. How do I do that?
I need the answer to be one of the 4 that is in each group, please.
D
Duke Carey
When you write a question in vague terms, you cannot expect explicit
instructions. None of us is a mindreader
At the least you should let us know:
Are your groups in ranges on the spreadsheet, or are they just logical
groups within the numbers 1-36, i.e., 1-9, 10-18, etc?
Do you want the 4 results to appear in a single cell, or in 4 separate cells?
instructions. None of us is a mindreader
At the least you should let us know:
Are your groups in ranges on the spreadsheet, or are they just logical
groups within the numbers 1-36, i.e., 1-9, 10-18, etc?
Do you want the 4 results to appear in a single cell, or in 4 separate cells?
B
bj
one way to do it would be to use two helper columns (or rows)besides the data
in one enter a designator for each group of four (1,1,1,1,2,2,2,2... 9,9,9,9)
in the other enter =rand() and copy down the column
select all three columns and user <data><sort) first be designator and
second be the rand column
each time you sort you will get a different combination of the top in each
designated set.
in one enter a designator for each group of four (1,1,1,1,2,2,2,2... 9,9,9,9)
in the other enter =rand() and copy down the column
select all three columns and user <data><sort) first be designator and
second be the rand column
each time you sort you will get a different combination of the top in each
designated set.