|
- Option Explicit
- Sub test()
- Dim hzDic As Object
- Dim hzArr, i&, lsArr
- Set hzDic = CreateObject("Scripting.Dictionary")
- hzArr = Sheet2.UsedRange.CurrentRegion
- For i = 2 To UBound(hzArr)
- hzDic(hzArr(i, 1) & hzArr(i, 3)) = hzDic(hzArr(i, 1) & hzArr(i, 3)) + 1
- Next
- lsArr = hzDic.keys
- Dim rng As Range
- For Each rng In Sheet1.Range("A3:A" & Sheet1.UsedRange.Rows.Count)
- For i = 0 To UBound(lsArr)
- If rng = Mid(lsArr(i), 1, 2) Then
- Select Case Mid(lsArr(i), 3, 1)
- Case "男"
- rng.Offset(0, 1) = hzDic(lsArr(i))
- Case "女"
- rng.Offset(0, 2) = hzDic(lsArr(i))
- End Select
- End If
- Next
- Next
-
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|