Sorting random numbers into equal categories

I am fairly new to spreadsheets and am wondering if there is a better solution than just manually comparing numbers. I have a bunch of batteries of different capacity that I need to sort into a number of groups where the total number in that group equals the average of all the cells combined divided by the total groups. It doesn't need to be exact, just very close. This block is an example. Scroll down to the colored one. I want each orange number to be the green number or as close as possible. I have the data set (blue to the right) that needs to be evenly distributed each time into the red cells. This block is an example of what I want to have every time I give it a block of data, I just don't know how to make it do that unless I manually 1 by 1 adjust it until it lines up. Anyone know how to do this? Thanks!

Hello and Welcome to Excel Forum.
Take a look at sheet 2 of the attached file and see if it looks like it could evolve into something useful.
The battery capacity is in column A (I used a random function for demonstration purposes).
The batteries are sorted by capacity largest to smallest in column B.
The pack assignments are made on a rotating basis in column C. (somewhere in the recesses of my mind I have a thought that there is a way to generate this number pattern by formula, however I want to make sure that this looks promising before trying to find it)
Variances are listed in column H. If those look to be within tolerance then we could pursue this line further, if not perhaps someone will get some inspiration for something better.
In the future please upload workbooks directly by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

I had said that I would try to remember the formula that generates the number pattern for column C so that it will make assignments for different numbers of packs.
A formula, pasted into C2 and copied down, that will do that is:

Formula:

Please Login or Register  to view this content.

The attached file makes use of the functionality offered by this formula and will work for the following factors of 60. Try changing D2 to 2,3,5,6,10, or 12.
Let us know if you have any questions.