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?

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?

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?