每格大於後3數 提取 (14968)

B5{=INDEX(2:2,SMALL(IF(($B2:$AM2>$C2:$AN2)*($B2:$AM2>$D2:$AO2)*($B2:$AM2>$E2:$AP2)*($E2:$AP2>0),COLUMN($B:$AM),99),COLUMN(A1)))&""

可改不固後3數{=INDEX(2:2,SMALL(IF((MMULT(N(N(OFFSET($A2,,ROW($1:$19)))>N(OFFSET($B2,,ROW($1:$19)+{1,2,3}-1))),{1;1;1})=3)*(MMULT(N(N(OFFSET($B2,,ROW($1:$19)+{1,2,3}-1))>0),{1;1;1})=3),ROW($2:$20),99),COLUMN(A1)))&""



留言