|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
'假设B列有序,,,
Option Explicit
Sub test()
Dim arr, i, sum, flag, p
arr = [a1].CurrentRegion.Offset(1).Resize(, 4)
ReDim brr(1 To UBound(arr, 1) - 1, 1 To 1)
For i = 1 To UBound(arr, 1) - 1
sum = sum + arr(i, 4)
If i > p + 1 Then If arr(i, 3) <> arr(i - 1, 3) Then flag = 1
If arr(i, 2) <> arr(i + 1, 2) Then
If flag = 0 Or sum < 8 Then brr(i, 1) = "否"
sum = 0: flag = 0: p = i
End If
Next
[f2].Resize(UBound(brr, 1)) = brr
End Sub |
评分
-
3
查看全部评分
-
|