Rotation

[Lee733]

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

 

[Lee733]

I copy and pasted from

C8 - =XLOOKUP(MIN(XLOOKUP(SEQUENCE(6),C$2:C7,D$2:D7,0,0,-1)),D$2:D7,C$2:C7,,0)
C9 - =MIN(XLOOKUP(SEQUENCE(6),C$2:C7,D$2:D7,0,0-1))+B8

 

[Anthony47]

D9 - =MIN(XLOOKUP(SEQUENCE(6),C$2:C8,D$2:D8,0,0-1))+B9           Your, WRONG
     =MIN(XLOOKUP(SEQUENCE(6),C$2:C8,D$2:D8,0,0,-1))+B9          CORRECT

Is that a typing error or...

 

[Lee733]

I copied your formulas to get it to work. Thanks again you are a genius!

 

[Anthony47]

I copied your formulas to get it to work

That's the right way!

If that resolves the problem then it'd be better to mark the discussion as Resoved; see the procedure: Mark as Solution