取符号後二個数据 (10662)


D2:E4=-LOOKUP(9,-MID(SUBSTITUTE($A2,"-",REPT(" ",99),LEN($A2)-LEN(SUBSTITUTE($A2,"-",))-2+COLUMN(A1)),99,ROW(1:99)))


另解=-LOOKUP(1,-LEFT(RIGHT(SUBSTITUTE($A2,"-",REPT(" ",99)),(3-COLUMN(A1))*99),ROW(1:99)))


留言