Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting unique data
Hi all,
i have a table like this Names A, B, C A,B B C B, C A, C C A A I want to count all the A or B or C that come up. In this example A=5, B=4, C=5. Hope the question is clear and many thanks for your help. Brie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting unique data
Try it like this:
=COUNTIF(A2:A10,"*A*") Or, put "A" in a cell then refer to that cell: C1 = A =COUNTIF(A2:A10,"*"&C1&"*") Both formulas will only count a cell once if it might contain more than one isnatance of "A". For example: A2 = A, A, A, B, C A2 will count as 1. -- Biff Microsoft Excel MVP "Brie" wrote in message ... Hi all, i have a table like this Names A, B, C A,B B C B, C A, C C A A I want to count all the "A" or "B" or "C" that come up. In this example A=5, B=4, C=5. Hope the question is clear and many thanks for your help. Brie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting unique data
Got it!
many thanks, Biff! "T. Valko" wrote: Try it like this: =COUNTIF(A2:A10,"*A*") Or, put "A" in a cell then refer to that cell: C1 = A =COUNTIF(A2:A10,"*"&C1&"*") Both formulas will only count a cell once if it might contain more than one instance of "A". For example: A2 = A, A, A, B, C A2 will count as 1. -- Biff Microsoft Excel MVP "Brie" wrote in message ... Hi all, i have a table like this Names A, B, C A,B B C B, C A, C C A A I want to count all the "A" or "B" or "C" that come up. In this example A=5, B=4, C=5. Hope the question is clear and many thanks for your help. Brie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting unique data
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Brie" wrote in message ... Got it! many thanks, Biff! "T. Valko" wrote: Try it like this: =COUNTIF(A2:A10,"*A*") Or, put "A" in a cell then refer to that cell: C1 = A =COUNTIF(A2:A10,"*"&C1&"*") Both formulas will only count a cell once if it might contain more than one instance of "A". For example: A2 = A, A, A, B, C A2 will count as 1. -- Biff Microsoft Excel MVP "Brie" wrote in message ... Hi all, i have a table like this Names A, B, C A,B B C B, C A, C C A A I want to count all the "A" or "B" or "C" that come up. In this example A=5, B=4, C=5. Hope the question is clear and many thanks for your help. Brie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique counting | Excel Discussion (Misc queries) | |||
Counting unique values | Excel Discussion (Misc queries) | |||
counting unique numbers in filtered data | Excel Worksheet Functions | |||
counting unique items | Excel Discussion (Misc queries) | |||
Counting Unique Values | Excel Worksheet Functions |