F3{=IFERROR(INDEX(B:B,SMALL(IF(ROUNDUP(C$3:C$11/TEXT(D$3:D$11,"0;;1"),)>=COLUMN(A:Z),ROW($3:$11)),ROW(A1)))&"-"&RIGHT(SMALL(IF(ROUNDUP(C$3:C$11/TEXT(D$3:D$11,"0;;1"),)>=COLUMN(A:Z),ROW($3:$11)/1%%+COLUMN(A:Z)),ROW(A1)),3),"")
G3=IF(F3="","",MIN(VLOOKUP(LEFT(F3),B:D,2,)-SUMIF(F$2:F2,LEFT(F3)&"*",G$2:G2),VLOOKUP(LEFT(F3),B:D,3,)))
留言
張貼留言