I need a formula or formulas to determine which part each person would receive if the idea is to give them approximately the same number of parts.
I sort the parts by quantity and give the first six people the part with the highest quantity.
I need a formula that will look at the person with the lowest total quantity and give them the next part.
The correct answer is below but it manual done. I can't figure out what formulas I could use to get the correct result.
Debbie
I sort the parts by quantity and give the first six people the part with the highest quantity.
I need a formula that will look at the person with the lowest total quantity and give them the next part.
The correct answer is below but it manual done. I can't figure out what formulas I could use to get the correct result.
Debbie