少了一组循环
- Sub Test2()
- Dim Arr, Brr, i&, j%, x%, n
- Arr = [a10].CurrentRegion
- [J12:AP12] = ""
- Brr = [J11:AP12]
- x = [j10].Value
- For i = 2 To UBound(Arr) - 1
- For j = 3 To UBound(Arr, 2)
- If Arr(i, j) = x Then
- For k = 1 To UBound(Brr, 2)
- For n = 3 To UBound(Arr, 2)
- If Arr(i + 1, n) = Brr(1, k) Then
- Brr(2, k) = Brr(2, k) + 1
- End If
- Next n
- Next k
- End If
- Next j
- Next i
- [j11].Resize(2, UBound(Brr, 2)) = Brr
- End Sub
复制代码
|