Dividing a list into equal groups

[abypfcs]

I will have a list of names that each will have a value attached to each name. This value will change each week.

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.

 

[facethegod]

How wolud you like your desired results to look?

 

[dcardno]

What algorithm have you established for making the determination? Especially if the number of entries grow large, this is not a trivial problem. See this Wikipedia article...

 

[Boller]

What algorithm have you established for making the determination? Especially if the number of entries grow large, this is not a trivial problem. See this Wikipedia article...

I think you must have misread the question.

 

[dcardno]

I think you must have misread the question.

Yes - I had (mis)understood that the value attached to the names had some relevance in determining the grouping. If not, the question is -give or take- trivial.