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.

ALPHA	Jul-14
A	206
B	839
C	422

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


</tbody>

Thanks!

 

[svendiamond]

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

 

[lucolem]

It's July 2014-May 2015.