201804061143二列相同 去重複 聚單格 (4276)

G3:I25{=IFERROR(INDEX($C:$C,SMALL(IF((MATCH($A$3:$A$34&$C$3:$C$34,$A$3:$A$34&$C$3:$C$34,)=ROW(A$3:A$34)-2)*($A$3:$A$34=$E3),ROW(A$3:A$34)),COLUMN(A1)))&" "&H3,"")

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





Powered by Xuite