#### abypfcs

##### Board Regular

- Joined
- Jul 17, 2005

- Messages
- 95

Some weeks there may be 20 names, some weeks there may be fewer, and some weeks more names. Up to 100 names.

I would like to be able to divide the group into either 2, 3, or 4 equal groups based on the values assigned to each person.

Example:

Johnson 3.5

Samuels 4.7

Jackson 5.3

Fernando 5.5

Smith 7.3

Lock 8.0

Bayles 8.1

Jones 9.0

If there were 4 groups, the first two names would be in Group A, the next two in Group B and so forth.

If there were 3 groups, there would be 3 in Group A, 3 in Group B and only 2 in Group C

If there were 2 groups, the first four names in Group A and the next four in Group B

I plan on having a cell that will state if there are to be 2, 3, or 4 groups.

Hopefully this will not be too difficult. Thanks for any suggestions.