Hi guys,

I tweaked the formula so we don't have to use 'high' and 'normal' to solve in column I.

I figured that I could rank the names in the input any way I want to get desired order.

=IF(R6>SUM($G$5:$G$14),INDEX($S$5:$S$431,MOD(R6-1,SUM($G$5:$G$14))+1),IF(COUNTIF($S$5:S5,S5)<VLOOKUP(S5,$F$5:$G$14,2,0),S5,INDEX($F$5:$F$14,SMALL(ROW($F$5:$F$14)-MIN(ROW($F$5:$F$14))+1,SUMPRODUCT(1/COUNTIF($S$5:S5,$S$5:S5))+1))))

I still cannot come up with an algorith to create the Scenario 2 pattern:

I tried to use the output from the first scenario and modify it but haven't had any luck so far. Let me know if you think of anything please.

T