|
- Option Explicit
- Sub 按第二种条件组合()
- Dim arr1, arr2, arr3(1 To 10 ^ 5, 1 To 5)
- Dim i&, x&, y&
- Dim sh As Worksheet
- Set sh = ThisWorkbook.Sheets(2)
- arr1 = sh.Range("C1:F" & sh.[C65536].End(xlUp).Row)
- arr2 = sh.Range("H1:J" & sh.[H65536].End(xlUp).Row)
- For x = 1 To UBound(arr1)
- For y = 1 To UBound(arr2)
- If arr2(y, 1) = arr1(x, 3) And arr2(y, 2) = arr1(x, 4) Then
- i = i + 1
- arr3(i, 1) = arr1(x, 1)
- arr3(i, 2) = arr1(x, 2)
- arr3(i, 3) = arr1(x, 3)
- arr3(i, 4) = arr1(x, 4)
- arr3(i, 5) = arr2(y, 3)
- End If
- Next
- Next
- [L1].Resize(i, 5) = ""
- [L1].Resize(i, 5) = arr3
- End Sub
复制代码
第二种情况的代码。 |
评分
-
查看全部评分
|