J8:K12{=INDEX(A:A,SMALL(IF(($D$2:$D$21<=$J$4)*($D$2:$D$21>=$K$4)*(MMULT(N(COUNTIF(OFFSET($F$2:$F$21,,{0,1,2}),">"&$F$2:$H$21)<10),{1;1;1})=3),ROW($2:$21),99),ROW(A1)))&""
另解{=INDEX(A:A,SMALL(IF((($D$2:$D$21<=$J$4)*($D$2:$D$21>=$K$4)*(RANK($F$2:$F$21,$F:$F)<=10)*(RANK($G$2:$G$21,$G:$G)<=10)*(RANK($H$2:$H$21,$H:$H)<=10)),ROW($2:$21),99),ROW(A1)))&""
留言
張貼留言