|
代码供参考。。。- Sub ykcbf() '//2024.2.23
- Dim arr, brr, d
- Set d = CreateObject("Scripting.Dictionary")
- b = [{"A1","B1","C1"}]
- Dim zrr(1 To 3, 1 To 1)
- With Sheets("Sheet1")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .Range("a1:c" & r)
- For i = 2 To UBound(arr)
- st = arr(i, 1)
- For x = 1 To UBound(b)
- If st = b(x) Then s = b(x): zrr(x, 1) = arr(i, 2)
- If Left(st, 1) = Left(b(x), 1) Then s = b(x)
- Next
- d(s) = d(s) + arr(i, 3)
- Next
- .[g2:i1000] = ""
- .[g2].Resize(d.Count, 1) = WorksheetFunction.Transpose(d.keys)
- .[h2].Resize(3, 1) = zrr
- .[i2].Resize(d.Count, 1) = WorksheetFunction.Transpose(d.items)
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
|