how many days
 

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?

how many days
 

Hi!

Do you want to count the unique entries?

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

Biff

"argument" wrote in message
...
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?

how many days
 

Biff, yes that's what I wanted to do.
It was helpfull, thank you!!!


"Biff" wrote in message
...
Hi!

Do you want to count the unique entries?

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

Biff

"argument" wrote in message
...
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?