- Sub test()
- Dim ar1, ar2, br(), i&, j1&, j2&
- ar1 = Range("a1").CurrentRegion
- ar2 = Range("e1").CurrentRegion
- ReDim br(1 To UBound(ar2), 1 To UBound(ar2, 2))
- For i = 3 To UBound(ar2)
- For j2 = 1 To 3
- For j1 = 1 To 3
- If ar2(i, j2) = ar1(i, j1) Then br(i, j2) = br(i, j2) & ar1(2, j1)
- Next
- Next
- Next
- [m1].Resize(i - 1, j2 - 1) = br
- End Sub
复制代码
如何快速统计二组中的数据与一组中数据的那个位(A位B位C位)相同?.rar
(16.04 KB, 下载次数: 3)
|