Generating groups based on #of names and performance

Thanks for the rep.

You're welcome. We appreciate the feedback!

Thanks for marking the question solved.

c2 =IFERROR(RANK(B2,$B$2:$B$36)+row()/1000000,"")

the red part makes sure you get all unique values.

INT(COUNTA([Student])/5) = this counts the available values in your range student (which is 26).

You want to group in 5 groups, so we divide by 5.

The INT makes sure it rounds to a value of 5.


F2 = if the value is > 5, then also add that student to the last group, otherwise determine the group.

Hope I exclained well enough.