# Dividing a list into equal groups

#### abypfcs

##### Board Regular
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.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### facethegod

##### Well-known Member
How wolud you like your desired results to look?

#### dcardno

##### Well-known Member
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

##### Banned
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

##### Well-known Member
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.

Replies
14
Views
757
Replies
11
Views
322
Replies
7
Views
1K
Replies
2
Views
1K
Replies
3
Views
139

1,191,415
Messages
5,986,428
Members
440,029
Latest member
GabSSSH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back