|
- Sub test()
- Dim rng As Range
- Dim d As Object
- Dim A(), t()
- Dim i As Long
-
- '统计次数
- Sheets(1).Select
- Set rng = Range("a1:c" & Range("a65536").End(xlUp).Row)
- A = rng.Value
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(A)
- d(A(i, 1) & A(i, 2)) = d(A(i, 1) & A(i, 2)) + 1
- Next i
- t = d.items
- For i = 2 To UBound(A)
- A(i, 3) = d(A(i, 1) & A(i, 2))
- Next i
- [a1].Resize(i - 1, 3) = A
- '高级筛选
- Sheets("Sheet2").Select
- rng.AdvancedFilter Action:=xlFilterCopy, _
- CriteriaRange:=Sheets("Sheet1").Range("Z1:Z2"), _
- CopyToRange:=Range("D1:F1"), _
- Unique:=False
- '按F列排升序
- Range("d1").CurrentRegion.Sort Key1:=Range("F1"), _
- Order1:=xlAscending, _
- Header:=xlYes
- End Sub
复制代码
将一个卡号在同一天出现的次数在2次或以上的列出来c.rar
(14 KB, 下载次数: 5)
|
评分
-
查看全部评分
|