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?[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Person 1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 2[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 3[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 4[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 5[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 6[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 7[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 8[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 9[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 10[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 11[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 12[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 13[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 14[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 15[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 16[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 17[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 18[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 19[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person 20[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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...
[TABLE="class: grid, width: 128"]
<tbody>[TR]
[TD="width: 64"]Person[/TD]
[TD="width: 64"]Group[/TD]
[/TR]
[TR]
[TD]Alice[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Barry[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Carl[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Denese[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Edward[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Florance[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Gary[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Hellen[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Keith[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
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