Dividing a column of numbers into equal groups

[Cybertech]

I have a spreadsheet with 32 rows of numbers in column A. I need to divide the rows into X number of groups where the sum of the numbers in the rows of each group are as equal as possible to the other groups. The number of groups will very depending on various circumstances.

I’ve tried various suggestions I found searching the forum, but I can’t get any of them to work properly.

Does anyone have a suggestion for a formula that might work here? I’ve attached an image with rows of numbers from one of the datasets. In this case I am looking to separate the numbers into six equal (as equal as possible) groups.

Thanks!

 

[SanjayGMusafir]

Give me the sample data using XL2BB and also update your profile and here about the version of Excel you are using. I can probably help you with this.

Also, it is important that the column just contains number and nothing is there in any other column corresponding to it. Give me sample data as close to real data as possible to help you.

 

[Cybertech]

Here is an example of an actual dataset. The goal here is to divide these rows into six groups where the sum of the numbers in each groups is as even as possible. I have stripped everything other than the actual numbers involved.

Example Data.xlsx
	A
1	19
2	9
3	33
4	5
5	21
6	1
7	8
8	1
9	33
10	12
11	14
12	27
13	1
14	10
15	6
16	69
17	28
18	10
19	15
20	47
21	1
22	36
23	15
24	19
25	3
26	9
27	10
28	46
29	32
30	18
31	18
32	58
Sheet1

Thanks

 

[bobbych]

I want to do this in excel also. there an online tool that will do this for you if that helps?