Hi All,
Need help in counting the MTD count of date without the duplicates.
My formula so far is, =COUNTIFS($A$5:$A$13,">="&($B$1)-(DAY($B$1)-1),$A$5:$A$13,"<="&($B$1),$C$5:$C$13,B2)
the problem is it counts all the duplicate Dates.
I attached here a sample excel file. hope it helps.
Thanks!
>>> Edit remarks: Kindly refer to the new attachment file in Post #10
Bookmarks