表格轉換 (15224)

I1:J6{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($B$2:$F$5>0,ROW($2:$5)/1%%+ROW($2:$5)^(B$1=$C$1)/1%+COLUMN($B:$F)^(B$1=$B$1)),ROW(A1)),4),"!R0C00"),),"")



留言