|
贴子内容与文件内说明不一致。按照你发贴内容做了一下,附件请参考。
- Private Sub CommandButton1_Click()
- Dim arr, brr, i&, j&, k&
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr) - 1, 1 To 1)
- For i = UBound(arr) To 5 Step -1
- For k = i - 1 To i - 3 Step -1
- For j = 2 To 3
- If arr(i, 3) = arr(k, j) Then Exit For
- Next j
- If j < 4 Then Exit For
- Next k
- If i - k = 4 Then brr(i - 1, 1) = 1 Else brr(i - 1, 1) = 0
- Next i
- [f2].Resize(UBound(brr)) = brr
- End Sub
复制代码 |
|