Here's my situation: I have a cumulative sum function in place that shows volume that I expect along a shipping dock at my distribution facility. I need a formula that re-starts the cumulative sum function if I enter a team number or some other indicator in an adjacent cell.
In the below sample, the first column with lots of data shows cumulative total volume. The second column shows volume per door. The third column shows the shipping door numbers. To the right, our supervisors will input the # of teams that are available that day and a formula determines the volume that each team should have to equally divide the work, in this case 15,956.
I want to be able to scan down the cumulative volumn column and place a "1" to indicate the ending door for team 1 at the door that has the cumulative volume that most closely resembles the optimum volume per team (15,956). At this point, I want the cumulative sum formula to reset so that I can quickly identify the door range for team 2 by looking again for a volume that is near 15,956, and so on.
Please help me finish this project!!!
Place team # at end door
***. total cube Door#
2138 2138 3 # teams Cube/team
3113 975 4 5 15,956
4739 1626 5
5179 440 6 Team Door range
6978 1799 7 1 3 13
8295 1317 8 2 14 #N/A
9985 1690 9 3 #N/A #N/A
11165 1180 10 4 #N/A #N/A
12176 1011 11 5 #N/A
14383 2207 12 6
1 15536 1153 13 7
16287 751 14 8
17577 1290 15 9
18434 857 16 10
Bookmarks