how many days

[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?

[Biff]

Hi!

Do you want to count the unique entries?

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

Biff

"argument" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>

[argument]

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


"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Do you want to count the unique entries?
>
> =SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
>
> Biff
>
> "argument" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>>
>
>