Evenly Distribute Cell Contents

[jbodel]

So we have to verify work that is placed into 15 different folders. the contents of the folders is irrelevant. We have four team members. What I am hoping to do is write a formula or some sort of calculation that can help figure this out automatically. So currently I review these numbers and add up all the contents in the Content Column (154) and then divide that by four team members and come up with an average of 38.5. So then I figure out manually that the first team member will have to verify folder A and B. Team member 2 will have to verify FOlder C, etc. Is there a formula or something that I could write that would do this faster or easier without manual intervention?

The actual data is much larger and there are more folders and team members. below is just an example.

This forum has been so helpful that I come back often and appreciate everyone's input and help. Thank you in advance.

Folder Name	Content
A	12
B	25
C	32
D	8
E	32
F	45

 

[KOKOSEK]

What if folder contains more than average, like F?

 

[KOKOSEK]

Cannot be delete empty post.

 

[KOKOSEK]

That's not ideal but in some way solve Your problem:

Book1
	A	B	C
1	Folder	files	Team member
2	A	6	1
3	B	19	2
4	C	9	3
5	D	11	4
6	E	11	5
7	F	4	6
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=RANDBETWEEN(1,20)
C3:C7	C3	=LET(Xaverg,SUM($B$2:$B$7)/4,oldCount,SUM($B$2:B3),newCount,SUM($B2:B3),Xcount,IF(C2=C1,oldCount,newCount),IF(Xcount>Xaverg,C2+1,C2))

There is a few issue as in my previous post or fact that it won't be equaly for all.

 

[KOKOSEK]

Hmmm. That's interesting.
What if we change it for (SUM divide by 3 not 4):

=LET(Xaverg,SUM($B$2:$B$7)/3,oldCount,SUM($B$2:B3),newCount,SUM($B2:B3),Xcount,IF(C2=C1,oldCount,newCount),IF(Xcount>Xaverg,C2+1,C2))

 

[jbodel]

Sorry been away for a bit. To answer your first question, there will always been some folders that contain more than the average while others contain less. I know how to figure out the sum and average, but in your second response, team member one would only need to verify six files while team member 2 has to verify 19. What I am hoping/looking for (hopefully it is possible) is (in your example) Team member one would verify the B folder (that contains 19) files, while team member 2 would verify folders C and D. I know the numbers are not going to be perfect, but as long as all team members had relatively the same amount of files to verify? Does that make sense or help?