L2:L19{=IFERROR(T(INDIRECT(TEXT(SMALL(IF(MMULT(N(B$2:G$5>0),ROW(1:6)^0)>=COLUMN(A:J),ROW($2:$5)/1%+99^(COLUMN(A:J)>1)),ROW(A1)),"!R0C00"),)),"")
M2:N19{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($B$2:$G$5>0,(ROW($2:$5)/1%+ROW($2:$5)^(A$1=$B$1))/1%+COLUMN($B:$G)),ROW(A1)),4),"!r0c00"),),"")
留言
張貼留言