201911181756去重复句子 从左向右去除重复 (6301)

B2 右拉 下拉{=IFERROR(C2&" "&INDEX(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",99)),(20-ROW($1:$19))*99-98,99)),SMALL(IF(MATCH(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",99)),(20-ROW($1:$19))*99-98,99)),TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",99)),(20-ROW($1:$19))*99-98,99)),)=ROW($1:$19),ROW($1:$19)),COLUMN(B1))),"")

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





Powered by Xuite