|
- Sub Macro1()
- Dim arr, brr, crr, i&, j&
- arr = Range("a2").CurrentRegion
- brr = Range("f2").CurrentRegion
- ReDim crr(1 To UBound(brr) - 2, 1 To 1)
- For i = 3 To UBound(brr)
- For j = 3 To UBound(arr)
- If arr(j, 2) >= brr(i, 1) And arr(j, 3) >= brr(i, 2) Then
- crr(i - 2, 1) = arr(j, 1): Exit For
- End If
- Next
- Next
- Range("h3").Resize(UBound(crr)) = crr
- End Sub
复制代码 |
|