Count Unique value

[Vinny1984]

[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD="align: right"]1/01/2019[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]6/01/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/01/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/01/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/01/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5/02/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8/02/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8/02/2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/02/2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

=SUMPRODUCT(1/COUNTIFS(A2:A10,A2:A10))

hey guys,
the above count shows me the unique value for the whole column - but how do i show how many unique values for Jan and Feb separately. I want the result to be 4 and 3.

thanks in advance

 

[lrobbo314]

For January,

=SUMPRODUCT(1/COUNTIFS(A2:A10,A2:A10)*(MONTH(A2:A10)=1))

For February,

=SUMPRODUCT(1/COUNTIFS(A2:A10,A2:A10)*(MONTH(A2:A10)=2))

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C
1	Date		Count
2	1/1/2019	Jan	4
3	1/6/2019	Feb	3
4	1/10/2019
5	1/10/2019
6	1/20/2019
7	2/5/2019
8	2/8/2019
9	2/8/2019
10	2/10/2019
Sheet

 

[Vinny1984]

Wow - both solution worked with ease - thanks guys

 

[DanteAmor]

Another way:



=SUMPRODUCT((MATCH($A$2:$A$10, $A$2:$A$10,0)=ROW($A$2:$A$10)-1)*(MONTH($A$2:$A$10)=1))
=SUMPRODUCT((MATCH($A$2:$A$10, $A$2:$A$10,0)=ROW($A$2:$A$10)-1)*(MONTH($A$2:$A$10)=2))