Sub 提取重复身份证号()
Dim arr, brr(), crr(), d As Object
Set d = CreateObject("scripting.dictionary")
arr = Range("B3:B" & Range("B1000").End(xlUp).Row)
For i = 1 To UBound(arr)
d(arr(i, 1)) = d(arr(i, 1)) + 1
Next i
For i = 1 To UBound(arr)
arr(i, 1) = arr(i, 1) & d(arr(i, 1))
Next i
ReDim brr(1 To d.Count, 1 To 1)
ReDim crr(1 To d.Count, 1 To 1)
a = d.Keys: B = d.Items
For i = 0 To d.Count - 1
If B(i) >= 2 Then
s = s + 1
brr(s, 1) = a(i)
crr(s, 1) = B(i)
End If
Next i
Sheets("考生资料分析").Range("D2").Resize(s, 1) = brr
Sheets("考生资料分析").Range("E2").Resize(s, 1) = crr