Large List into Average Groups

[lucolem]

Hello,
I have a very large list that I need to split equally between, 5 people based on average. This list is by month and alphabet, and I need to take the total counts and split them between 5 people so they would each have around the same alphabet count. In the end, I would have one person with A-F, the next with G-K, the next with L-O, and so on, and they need to be as equal as possible.

Sticking to Excel, no VBA.

Any suggestions?

Thanks!

 

[svendiamond]

Can you show part of your spreadsheet either by a screenshot or maybe copy-and-paste?

 

[lucolem]

Here's a snapshot of the corner - the alpha continues down A-Z and the month continues across July-May with grand totals and averages as the final 2 columns/rows. So, essentially what I want to do is take the average for July-May for all A-Z and group them by 5 people...A-D for one person, E-J for the next, etc as equally as possible. I'm doing it now manually, thought there may be a better way.

[TABLE="width: 102"]


<colgroup><col style="width: 51pt;" span="2" width="68">
<tbody>[TR]

[TD="class: xl65, width: 68, bgcolor: #DCE6F1"]ALPHA[/TD]

[TD="class: xl66, width: 68, bgcolor: #DCE6F1, align: right"]Jul-14[/TD]

[/TR]

[TR]

[TD="class: xl67, bgcolor: transparent"]A[/TD]

[TD="bgcolor: transparent, align: right"]206[/TD]

[/TR]

[TR]

[TD="class: xl67, bgcolor: transparent"]B[/TD]

[TD="bgcolor: transparent, align: right"]839[/TD]

[/TR]

[TR]

[TD="class: xl67, bgcolor: transparent"]C[/TD]

[TD="bgcolor: transparent, align: right"]422[/TD]

[/TR]


</tbody>[/TABLE]

Thanks!

 

[svendiamond]

July 2014 through May 2015? Or do you mean May 14 through July 14?

 

[lucolem]

It's July 2014-May 2015.