201803100942比对二列数据有與无 ;同列有重复 顯最上面 (4152)

G3:G8{=INDEX(A:A,TEXT(MIN(IF((COUNTIF(D$3:D$8,A$3:A$8)=0)*(COUNTIF(G$2:G2,A$3:A$8)=0),ROW(A$3:A$8))),"0;;!999"))&""

H3:H8{=INDEX(D:D,TEXT(MIN(IF((COUNTIF(A$3:A$8,D$3:D$8)=0)*(COUNTIF(H$2:H2,D$3:D$8)=0),ROW(A$3:A$8))),"0;;!999"))&""

B3:B8(同列有重复 顯最上面)=IF(COUNTIF(A4:A8,A3),"重复","")

E2:E8(同列有重复 顯最上面)=IF(COUNTIF(D4:D8,D3),"重复","")

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





Powered by Xuite