|
把镇名+村名作为字典的key就行了。- Sub tt()
- Set d = CreateObject("scripting.dictionary") '镇+村
- Set d1 = CreateObject("scripting.dictionary") '身份证
- Set d2 = CreateObject("scripting.dictionary") '大于10亩身份证
- With Sheets("数据库")
- ori = .Range("A4:u" & .Cells(Rows.Count, 1).End(xlUp).Row).Value
- End With
-
- For i = 1 To UBound(ori)
- If ori(i, 1) <> "" Then
- sr = ori(i, 15) & ori(i, 16) '15+16:数据库-镇+村
- sr1 = ori(i, 21) '21数据库-身份证
- ms = ori(i, 5) '亩数
- If Not d.exists(sr) Then
- n = n + 1
- d(sr) = n
- ' brr(n, 0) = sr
- End If
- k = d(sr)
- If Not d1.exists(sr1) Then brr(k, 1) = brr(k, 1) + 1: d1(sr1) = "" '户数总计
- brr(k, 2) = brr(k, 2) + ms '亩数总计
- If ms > 10 Then
- brr(k, 4) = brr(k, 4) + ms '大于10亩的亩数总计
- If Not d2.exists(sr1) Then brr(k, 3) = brr(k, 3) + 1: d2(sr1) = "" '大于10亩的户数总计
- End If
- End If
- Next
-
- With Sheets("新问题")
- crr = .Range("a6:o" & .[a65536].End(3).Row)
- For i = 1 To UBound(crr)
- sr = crr(i, 1) & crr(i, 2)
- k = d(sr)
- ' For j = 2 To 5
- ' crr(i, j) = brr(k, j - 1)
- ' Next
- crr(i, 3) = brr(k, 1): crr(i, 4) = brr(k, 2)
- crr(i, 14) = brr(k, 3): crr(i, 15) = brr(k, 4)
- Next
- .Range("a6:o" & .[a65536].End(3).Row) = crr
- End With
- End Sub
复制代码 |
|