Please try at
F3
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$3:$B$9)/(COLUMN($A$1:$Z$1)< =CEILING($C$3:$C$9,1)),ROWS(F$3:F3))),"")
G3
=IF(COUNTIF(F$3:F3,F3)< VLOOKUP(F3,$B$3:$C$9,2,),1,VLOOKUP(F3,$B$3:$C$9,2,)-COUNTIF(F$2:F2,F3))
Please try at
F3
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$3:$B$9)/(COLUMN($A$1:$Z$1)< =CEILING($C$3:$C$9,1)),ROWS(F$3:F3))),"")
G3
=IF(COUNTIF(F$3:F3,F3)< VLOOKUP(F3,$B$3:$C$9,2,),1,VLOOKUP(F3,$B$3:$C$9,2,)-COUNTIF(F$2:F2,F3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks