Prev: Troubleshoot
Next: more details please
From: Curtis on 4 Jun 2010 10:41
Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce
From: Jackpot on 4 Jun 2010 10:47
Do you mean a unique count..=COUNT() will give you a total count of numeric
values (including date, time, numbers etc; ).

Why dont you post few samples...

"Curtis" wrote:

> Need a formaula to look at an entire column and count the number of
> different times (say date of product)
>
> Thanks
> --
> ce
From: Curtis on 4 Jun 2010 11:04
Yes sorry unique count.

If I have Products in column b

apples
apples
peach
grape
lemon

I want to count the number of unique products as in this case the result
would be 4
--
ce


"Jackpot" wrote:

> Do you mean a unique count..=COUNT() will give you a total count of numeric
> values (including date, time, numbers etc; ).
>
> Why dont you post few samples...
>
> "Curtis" wrote:
>
> > Need a formaula to look at an entire column and count the number of
> > different times (say date of product)
> >
> > Thanks
> > --
> > ce
From: Jackpot on 4 Jun 2010 11:12
Try the below.

=SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B20&""))


"Curtis" wrote:

> Yes sorry unique count.
>
> If I have Products in column b
>
> apples
> apples
> peach
> grape
> lemon
>
> I want to count the number of unique products as in this case the result
> would be 4
> --
> ce
>
>
> "Jackpot" wrote:
>
> > Do you mean a unique count..=COUNT() will give you a total count of numeric
> > values (including date, time, numbers etc; ).
> >
> > Why dont you post few samples...
> >
> > "Curtis" wrote:
> >
> > > Need a formaula to look at an entire column and count the number of
> > > different times (say date of product)
> > >
> > > Thanks
> > > --
> > > ce
From: Dave Peterson on 4 Jun 2010 11:15
If you wanted to count the number of unique entries in that range, you could use
a formula like:

=sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in xl2007)

Curtis wrote:
>
> Need a formaula to look at an entire column and count the number of
> different times (say date of product)
>
> Thanks
> --
> ce

--

Dave Peterson
 | 
Pages: 1
Prev: Troubleshoot
Next: more details please