I have a list of 133 widgets (for simplicity sake). Each widget has a unique name.
Each widget is also assigned a number from 4 to 14000, but some widgets do have duplicate, assigned numbers.
I want to assign all of the 133 widgets to one (1) of twelve (12) groups, named Group 1, Group 2, and so on. However, I want the groups to be (approximately), numerically balanced, based upon the sum of the individual numbers that have been pre-assigned to each widget.
The total value of my widgets is 70,228. I'm trying to figure out how to tell Excel to create 12 groups and have the numeric value of each group approximately 5,852.
I hope this makes sense.
I can't seem to find an Excel formula to do this. Maybe someone has an idea for a formula or knows of one?
Thank you,
Ed
Each widget is also assigned a number from 4 to 14000, but some widgets do have duplicate, assigned numbers.
I want to assign all of the 133 widgets to one (1) of twelve (12) groups, named Group 1, Group 2, and so on. However, I want the groups to be (approximately), numerically balanced, based upon the sum of the individual numbers that have been pre-assigned to each widget.
The total value of my widgets is 70,228. I'm trying to figure out how to tell Excel to create 12 groups and have the numeric value of each group approximately 5,852.
I hope this makes sense.
I can't seem to find an Excel formula to do this. Maybe someone has an idea for a formula or knows of one?
Thank you,
Ed