連續非空 判斷位置 五狀況 (14808)

K2=IFERROR(LOOKUP(SUMPRODUCT((A2:I2<>"")*(B2:J2<>"")*COLUMN(A:I)),{1,5,7},{"右邊","中間","左邊"}),IF((A2<>"")*(J2<>""),"二邊","X"))