Hi there,
I have a list of people (some old, some young). I track the numbers of young and old and total them up every quarter (4 times per year).
I have a formula which totals the number of old and young , every quarter.
I need a formula to randomly assign the 5 younger people (Cell I24), into Group A and B (cells K24 and L24). Ideally, the block soze of randomisation should be 1:1. For every 2 people, one should be assigned to Group A and one to B. For every 10 older people, 5 get assigned to group A, and 5 assigned to Group B.
Of course I know it does not work when we only have an odd number, such as 5 older people.
Likewise, for the 2 younger people, i also need to randomly assign them to Group A and B too (Cell M24 and N24).
Please would anyone be able to help ?
I have a list of people (some old, some young). I track the numbers of young and old and total them up every quarter (4 times per year).
I have a formula which totals the number of old and young , every quarter.
I need a formula to randomly assign the 5 younger people (Cell I24), into Group A and B (cells K24 and L24). Ideally, the block soze of randomisation should be 1:1. For every 2 people, one should be assigned to Group A and one to B. For every 10 older people, 5 get assigned to group A, and 5 assigned to Group B.
Of course I know it does not work when we only have an odd number, such as 5 older people.
Likewise, for the 2 younger people, i also need to randomly assign them to Group A and B too (Cell M24 and N24).
Please would anyone be able to help ?
many thanksrow | A | B | C | D | E | F | G | H | I | J | K | L | M | N |
| COLUMN | ||||||||||||||
| 22 | ||||||||||||||
| 23 | QUARTER | Total younger | Total older | YOUNGER GROUP A | YOUNGER GROUP B | OLDER GROUP A | OLDER GROUP B | |||||||
| 24 | 2024-Q2 | 2 younger | 1 younger | 1 older | 1 younger | 1 younger | 1 older | 5 | 2 |
