<colgroup><col><col></colgroup><tbody>
Date
Count
1/01/2019
7
6/01/2019
10/01/2019
10/01/2019
20/01/2019
5/02/2019
8/02/2019
8/02/2019
10/02/2019
</tbody>
=SUMPRODUCT(1/COUNTIFS(A2:A10,A2:A10))
hey guys,
the above count shows me the unique value for the whole column...