| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of instances of same data | Excel Discussion (Misc queries) | |||
| count number of instances a number occurs | Excel Worksheet Functions | |||
| Count the number of Instances | Excel Discussion (Misc queries) | |||
| In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
| Count number of instances in sheet e.g. how many males/females | Excel Worksheet Functions | |||
![Curtis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
