H2:H5{=INDEX(B:B,SMALL(IF(MMULT(N(COUNTIF(OFFSET(C$2:C$21,,{0,1,2}),">"&C$2:E$21)+1<=O$2),{1;1;1})=3,ROW($2:$21),4^8),ROW(A1)))&""
I2:I5{=INDEX(B:B,SMALL(IF((MMULT(N(COUNTIF(OFFSET(C$2:C$21,,{0,1,2}),">"&C$2:E$21)+1>O$6),{1;1;1})=3)*(RANK(F$2:F$21,F:F)<=O$10),ROW($2:$21),4^8),ROW(A1)))&""
格式化 (指定前名次 藍色) C2:E21=RANK(C2,C:C)<=$O$2
格式化 (指定後名次 紅色) C2:E21 =RANK(C2,C:C)>$O$6
格式化 (第四次 指定前名次 綠色) F2:F21 =RANK(F2,F:F)<=$O$10
留言
張貼留言