- Sub demo()
- Dim arr, brr(), i%, j%
- With Sheets("数据")
- arr = .Range("A2:B" & .Cells(Rows.Count, "A").End(xlUp).Row)
- End With
- For i = LBound(arr) To UBound(arr)
- If arr(i, 1) = "李" Then
- j = j + 1
- ReDim Preserve brr(1 To j)
- brr(j) = arr(i, 2)
- End If
- Next
- Sheets("需要计算的").Range("B2").Resize(j, 1) = Application.Transpose(brr)
- End Sub
复制代码 |