Count if is in a range date of month and delete duplicates

[mialex18]

Hello everyone.

I want to count how many "codes" I have but removing the duplicated within the number of the month (jan,feb,etc) according to a date given to each code.

Basically the attached document is the data I'm using.

Hope somebody can help,
thanks in advice

[outofthehat]

If I understand you correctly, you only want to count unique combinations of date and code. So when code 1000047549 appears twise on 23-Jan, that should only be counted once. If I have interpreted corrently, then...

There's probably a cleverer way, but this is reasonably clear to read...
In the attached:
Column D: To identify the month from the date, use MONTH(). NB you need to be a bit cleverer if you want this to roll over into the new year. As written, it'll add up Januaries across all years.
Column E: Generates a composite text value, combining code and date. It doesn't need the TEXT function or the slash, but that makes it easier to see what's going on.
Column F: The key bit in this column is where the $$ go. F3 contains =COUNTIFS($E$3:E3,E3). When you copy that down, you get =COUNTIFS($E$3:E4,E4) and so on. Short version is, you get a running total of the number of times that unique Code/Date combination has happened.

Column I: I just put the month numbers in to make the formula easy to copy.
Column J: =COUNTIFS(D:D,I3,F:F,1). This counts the number of times you have the right month, but only counts the first instance of a code/date combo, by looking for a 1 in column F.

[outofthehat]

...and having re-read your post, there is a chance that you just want to count the number of unique codes happening in the month. (So would count a code only once if it happens on 2 different days in the month). I have added a couple of extra columns. Same principle, just a different composite to check for duplicates. Happens to return the same results on your data set.

[Czeslaw]

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Code", type number}, {"Date", type datetime}}),
    #"Extracted Month Name" = Table.TransformColumns(#"Changed Type", {{"Date", each Date.MonthName(_), type text}}),
    #"Removed Duplicates" = Table.Distinct(#"Extracted Month Name"),
    #"Grouped Rows" = Table.Group(#"Removed Duplicates", {"Date"}, {{"Count", each Table.RowCount(_), type number}})
in
    #"Grouped Rows"

[josephteh]

Try, F3=COUNTA(UNIQUE(FILTER($B$3:$B$40,TEXT($C$3:$C$40,"mmmm")=E3))), copy down.

[josephteh]

Modified above formula, =IFERROR(IF(MATCH(E3,TEXT(C3:C40,"mmmm"),0),COUNTA(UNIQUE(FILTER($B$3:$B$40,TEXT($C$3:$C$40,"mmmm")=E3)))),0)

[CARACALLA]

F3=IFERROR(ROWS(UNIQUE(FILTER($B$3:$B$40,(MONTH($C$3:$C$40)=MONTH($E3&0))*($C$3:$C$40<>"")))),"")

Copy down