202002161516二數值間 顯所有數字 (6591)

D2:M7{=IFERROR(SMALL(IF((COLUMN($A:$Z)-RIGHT(SMALL(IFERROR(LEFT(TRIM(MID(SUBSTITUTE($B2,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),{1,2})*1,)+ROW($1:$9)/1%,ROW($1:$9)*2),2)>=0)*(COLUMN($A:$Z)-RIGHT(SMALL(IFERROR(RIGHT(TRIM(MID(SUBSTITUTE($B2,",",REPT(" ",99)),ROW($1:$9)*99-98,99)),{1,2})*1,)+ROW($1:$9)/1%,ROW($1:$9)*2),2)<=0),COLUMN($A:$Z)),COLUMN(A1)),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite