先左列後右 隔行顯示 (14263)

F2{=IF(MOD(ROW(A1),2),IFERROR(RIGHT(SMALL(IF(A$2:C$399,{1,2,3}*10^7+ROW($2:$399)*10^4+$A$2:$C$399),ROW(A2)/2),4)*1,""),"")



留言