how many days

A

argument

Hi excel experts!
I've tried to count how many different values do I have in one column, but I
haven't manage it with any of the COUNT function. For example: in column A
there are 150 imputs -dates, some of those are the same. I want to know the
number of days that are registered in my column A.
Can anyone help me? Pls?
 
B

Biff

Hi!

Do you want to count the unique entries?

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

Biff
 
Top