D2{=IFERROR(SMALL(IF(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B$2:B$5,"-",","),",",REPT(" ",99)),COLUMN(A:I)*198-99,99))-MMULT((0&TRIM(MID(SUBSTITUTE(SUBSTITUTE(B$2:B$5,"-",","),",",REPT(" ",99)),COLUMN(A:I)*198-99,99)))*1,ROW(1:9)^0)/(LEN(B$2:B$5)-LEN(SUBSTITUTE(B$2:B$5,"-",)))<0,),{1;2;3;4}*10+COLUMN(A:I)),ROW(A1)),"")
E2 =D2 公式後面 <0 改 >=0
G2:H8=IF(D2="","",INDEX($A$2:$A$5&"-"&TRIM(MID(SUBSTITUTE(SUBSTITUTE($B$2:$B$5,"-",","),",",REPT(" ",99)),COLUMN($A:$E)*198-197,99)),LEFT(D2),RIGHT(D2)))
留言
張貼留言