O2:S11{=INDEX($B:$B,RIGHT(LARGE(IF(MMULT(RIGHT(SMALL(ROW(1:15)/1%%+$C$2:$L$16,ROW($1:$15)*10+1-TRANSPOSE(ROW(INDIRECT("1:"&$N2)))),4)*1,ROW(INDIRECT("1:"&$N2))^0)>=LARGE(MMULT(RIGHT(SMALL(ROW(1:15)/1%%+$C$2:$L$16,ROW($1:$15)*10+1-TRANSPOSE(ROW(INDIRECT("1:"&$N2)))),4)*1,ROW(INDIRECT("1:"&$N2))^0),3),MMULT(RIGHT(SMALL(ROW(1:15)/1%%+$C$2:$L$16,ROW($1:$15)*10+1-TRANSPOSE(ROW(INDIRECT("1:"&$N2)))),4)*1,ROW(INDIRECT("1:"&$N2))^0)/1%+ROW($2:$16),99),COLUMN(A1)),2))&""
M2:M16=SUMPRODUCT(LARGE($C2:$L2,ROW(INDIRECT("1:"&M$1))))
留言
張貼留言