If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count number of instances
Need a formaula to look at an entire column and count the number of
different times (say date of product) Thanks -- ce |
#2
|
|||
|
|||
Count number of instances
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 |
#3
|
|||
|
|||
Count number of instances
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 |
#4
|
|||
|
|||
Count number of instances
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 |
#5
|
|||
|
|||
Count number of instances
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 |
Thread Tools | |
Display Modes | |
|
|