非空 取二數據 (10914)


B7:I12{=IFERROR(INDIRECT(TEXT(SMALL(IF((OFFSET($A6,MATCH(1=1,$A7:$A12<>"",),)=$A$2:$A$4)*($B$2:$I$4>0),{2;3;4}^MOD(ROW(A2),2)/1%+COLUMN($B:$I)),COLUMN(A1)),"!R0C00"),),"")


留言