轉換 非空彙整 (14679)

N2:P12{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF($B$3:$J$5>0,$B$2:$J$2/1%%+IF(COLUMN(A1)=3,2,{3;4;5})/1%+COLUMN($B:$J)^(COLUMN(A1)>1)),ROW(A1)),4),"!R0C00"),),"")



留言