求助怎么统计两列数据比较？谢谢

mykitami · 发表于 2024-7-1 21:32

=SUM(N(BYROW(FILTER(B2:C10,A2:A10=E2)*{1,-1},SUM)>0))

zhangcheng6688 · 发表于 2024-7-2 06:36

学习一下字典，打扰了
Sub test()
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
If arr(i, 2) > arr(i, 3) Then
d(arr(i, 1)) = d(arr(i, 1)) + 1
End If
Next
brr = [e2].CurrentRegion
For i = 2 To UBound(brr)
brr(i, 2) = d(brr(i, 1))
Next
[e2].CurrentRegion = brr
End Sub

大道无形5613 · 发表于 2024-7-2 10:14

=FILTER(A2:A10,N(B2:B10>C2:C10)=1)

		自动登录	找回密码
密码			免费注册

[求助] 求助怎么统计两列数据比较？谢谢

评分