|
楼主 |
发表于 2019-3-11 12:26
|
显示全部楼层
本帖最后由 WYS67 于 2019-3-11 15:43 编辑
版主老师:请看截图,当每周期间隔序号的N1指定某些数值时,最后那个周期的下面,L:N列有时会出现连续的“1”,是什么原因造成的?
应该怎样屏蔽这些不符合运算规则的“1”为空白?
Public Function XHCOUNTIF(QY As Range, ZQ, tj, Optional x = 0, Optional y As Range)
Application.Volatile
arr = QY
If y Is Nothing Then
crr = Cells(QY(1).Row, 5).Resize(UBound(arr))
Else
crr = y
End If
For s = UBound(crr) To 1 Step -1
If crr(s, 1) <> "" Then Exit For
Next
ReDim brr(1 To UBound(crr), 1 To 1) As Variant
For i = 1 To UBound(crr)
brr(i, 1) = ""
Next
n = 1
m = crr(1, 1) + ZQ - 1
For i = 1 To s
If m <= crr(s, 1) Then
For j = n To s
If crr(j, 1) > m Then
n = j
m = m + ZQ
Exit For
Else
If Val(tj) = Val(arr(j, 1)) Then
brr(i, 1) = Val(brr(i, 1)) + 1
End If
End If
Next j
Else
For j = n To UBound(crr)
If Len(crr(j, 1)) > 0 Then
If tj = arr(j, 1) Then
brr(i, 1) = Val(brr(i, 1)) + 1
End If
End If
Next j
If x = 0 Then
brr(i, 1) = ""
End If
Exit For
End If
Next
XHCOUNTIF = brr
End Function
无法上传有问题的附件。郁闷。excelhome论坛这两天很多时候总是上传不了附件。 |
|