|
- Sub test()
- Dim arr, ar, brr(), i&, j&
- arr = Range("a2:a" & [a65536].End(3).Row)
- ar = Range("e2:e" & [e1].End(4).Row)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- For j = UBound(ar) To 2 Step -1
- If InStr(arr(i, 1), ar(j, 1)) Then Exit For
- Next
- brr(i, 1) = IIf(j > 1, ar(j, 1), 0)
- Next
- [g2].Resize(i - 1) = brr
- End Sub
复制代码
提取指定的值.rar
(87.43 KB, 下载次数: 9)
|
|