C
Curtis
Need a formaula to look at an entire column and count the number of
different times (say date of product)
Thanks
different times (say date of product)
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jackpot
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...
values (including date, time, numbers etc; ).
Why dont you post few samples...
C
Curtis
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
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
J
Jackpot
Try the below.
=SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B20&""))
=SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B20&""))
D
Dave Peterson
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)
a formula like:
=sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in xl2007)