|
发表于 2012-2-2 20:41
|
显示全部楼层
本楼为最佳答案
- Sub aa()
- Dim d As New Dictionary
- Dim arr, arr1
- Dim i As Long, j As Long
- arr = Range("A2:B" & [A65536].End(xlUp).Row)
- ReDim arr1(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- d(Month(arr(i, 1)) & "-" & Day(arr(i, 1))) = ""
- Next i
- For i = 1 To d.Count
- For j = 1 To UBound(arr)
- If Month(arr(j, 1)) & "-" & Day(arr(j, 1)) = d.Keys(i - 1) Then
- n = n + 1
- arr1(n, 1) = arr(j, 1)
- arr1(n, 2) = arr(j, 2)
- End If
- Next j
- Next i
- Range("D2:E" & [D65536].End(xlUp).Row).ClearContents
- Range("D2").Resize(UBound(arr1), 2) = arr1
- End Sub
复制代码 |
评分
-
查看全部评分
|