進步獎 依原排名與進步數 (12740)

A3:I24{=OFFSET($J$2,SMALL(IF((LOOKUP($L$3:$L$24,{0,5,11,16},{0,1,2,3})=INT(COLUMN(C1)/3))*($L$3:$L$24-$M$3:$M$24>=CHOOSE(INT(COLUMN(C1)/3),2,3,5)),ROW($1:$22),4^8),ROW(A1)),MOD(COLUMN(A1)-1,3)+1)&""



留言