202002171108重复只刪一个 ,單一不刪 (6594)

F2:H12{=INDEX(A:A,SMALL(IF((COUNTIF(OFFSET($C$2,,,ROW($1:$14)),$C$2:$C$15)<COUNTIF($C:$C,$C$2:$C$15))+(COUNTIF($C:$C,$C$2:$C$15)=1),ROW($2:$15),4^8),ROW(A1)))&""

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





Powered by Xuite