G2{=INDEX(B:B,SMALL(IF(CEILING(C$2:C$6/E$2,1)>=COLUMN(A:I),ROW($2:$6),99),ROW(A1)))&""
H2=IF(G2="","",MIN(VLOOKUP(G2,B:C,2,)-COUNTIF(G$1:G1,G2)*E$2,E$2))
另解G2{=INDEX(B:B,SMALL(IF((C$2:C$6>(COLUMN(A:I)-1)*E$2),ROW($2:$6),99),ROW(A1)))&""
另解H2=IF(G2="","",MEDIAN(,E$2,VLOOKUP(G2,B:C,2,)-COUNTIF(G$1:G1,G2)*E$2))
留言
張貼留言