Assign people to groups of 9

[y3tter]

Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc?

Person 1	1
Person 2	1
Person 3	1
Person 4	1
Person 5	1
Person 6	1
Person 7	1
Person 8	1
Person 9	1
Person 10	2
Person 11	2
Person 12	2
Person 13	2
Person 14	2
Person 15	2
Person 16	2
Person 17	2
Person 18	2
Person 19	3
Person 20	3

<tbody>
</tbody>

edit, this should have just been 2 columns

 

[Fluff]

How about, in B1 copied down
=ROUNDUP(ROW()/9,0)

 

[GR00007]

Please let me know if it works for you...

Person	Group
Alice	1
Barry	1
Carl	1
Denese	1
Edward	1
Florance	1
Gary	1
Hellen	1
Ian	1
Jane	2
Keith	2

<tbody>
</tbody>

In B2 (Alice) just put a 1
In C2 (Barry) place and copy down.

=IF(MOD(ROW(A3) -1,9) = 1,B2+1,B2)

This will add 1 each ninth person.

 

[y3tter]

Perfect, thank you!!

 

[y3tter]

Thank you

 

[Fluff]

Glad we could help & thanks for the feedback