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?

Use Index() with Randbetween()


"Janet" wrote:

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?

"Janet" wrote:

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.

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?



"Janet" wrote:



"Janet" wrote:

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.

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.


"Janet" wrote:

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?