Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count different instances in a list
I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the
different instances. So in this example it would be 3 because bbb is repeated. Is there a formula that does this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count different instances in a list
mmatz,
Assuming that your list is in cells A1:A5, if you put this formula in A7, it should accomplish what you desi =countif(A1:A5,"bbb") HTH, Conan "mmatz" wrote in message ... I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the different instances. So in this example it would be 3 because bbb is repeated. Is there a formula that does this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count different instances in a list
This one is an array formula and need to be committed with Shift+Ctrl+Enter
=SUM(1/COUNTIF(C1:C6,C1:C6)) This is committed with just Enter =SUMPRODUCT(--(C1:C6<""),1/COUNTIF(C1:C6,C1:C6&"")) Of course, change C1:C6 to fit your situation best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mmatz" wrote in message ... I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the different instances. So in this example it would be 3 because bbb is repeated. Is there a formula that does this? |
#4
|
|||
|
|||
Quote:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) where A1:A10 contain your data to count. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Instances of value in two columns | 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 | |||
Formula to use to count instances of in Excel | Excel Worksheet Functions | |||
Count Instances | Excel Discussion (Misc queries) |