求C列中不和A列重复的数据，请帮忙指教，谢谢

q1752

求C列中不和A列重复的数据
求助在附件中


请帮忙指教，谢谢

liyanghu

C列本身又有重复的……凭空增加了难度，火车太长，就不开了，顶上去让大佬们出手

xuleiren

d2=IF(COUNTIF($A$2:$A$11,C2),"重复","不重复")

1055751654

晕菜了，      没晕，就是条件格式，真的晕了，不是条件格式
Option Explicit


Sub s()
Dim d, arr, Q, rng, rngs
Set d = CreateObject("Scripting.Dictionary")
arr = Range("c1:c" & Cells(Rows.Count, 3).End(3).Row)
    For Q = 2 To UBound(arr)
    d(arr(Q, 1)) = "": Next Q
    For Each rng In d.keys
    Set rngs = Columns(1).Find(rng, , , 1)
    If Not rngs Is Nothing Then d.Remove rng
    Next rng
Range("d1") = "姓名"
Range("d2").Resize(d.Count) = Application.Transpose(d.keys)
End Sub

bpsinopec

=INDEX(C:C,SMALL(IF(COUNTIF($A$2:$A$11,$C$2:$C$26),999,ROW($C$2:$C$26)),ROW(1:1)))