非空取資料 (15069)

先上下後左右 J2{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(B$2:H$7>0,ROW($2:$7)/1%+COLUMN(B:H)*10001),ROW(A1)),4),"!R0C00"),),"")

先左右後上下 K2{=IFERROR(INDIRECT(TEXT(SMALL(IF(B$2:H$7>0,ROW($2:$7)/1%+COLUMN(B:H)),ROW(A1)),"!R0C00"),),"")