Prev: TroubleshootNext: 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: TroubleshootNext: more details please