条件去重

luiiq

按日期条件去重

无关岁月

1. =IFERROR(ROWS(UNIQUE(FILTER(A$2:A$1734,(C$2:C$1734=F2)*(LEFT(B$2:B$1734,7)="2024-06")))),0)

复制代码

quqiyuan

1. =COUNT(0/((UNIQUE(FILTER(A:A,(C:C=F2)*(TEXT(B:B,"e-m")="2024-6"),"")))<>""))

复制代码

飞天篮球猪

zhangcheng6688

学习一下字典，打扰了
Sub test()
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
   rq = Mid(arr(i, 2), 1, 7)
   If rq = #6/1/2024# Then
      If Not d.exists(arr(i, 3)) Then
         Set d(arr(i, 3)) = CreateObject("scripting.dictionary")
      End If
      d(arr(i, 3))(arr(i, 1)) = d(arr(i, 3))(arr(i, 1)) + 1
   End If
Next
brr = [f1].CurrentRegion
For i = 2 To UBound(brr)
   If Not d.exists(brr(i, 1)) Then
      brr(i, 3) = 0
   Else
      brr(i, 3) = d(brr(i, 1)).Count
   End If
Next
[f1].CurrentRegion = brr
End Sub