Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
I have a list of codes in a column, each code will be appearing many times. I
need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
It depends.
If you need a formula, then you have to write a macro, as far as I know. If you want a one time count, then create a pivot table with just this column, then count the number of items. If you can sort the list, in a new column use a formula like IF(A2=A1,0,1), then make the sum of this column. Sena wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Sena, Try this
=SUM(1/COUNTIF(A1:A10,A1:A10)) Adjust to the size of your range then enter it with Ctrl+Shift+Enter Mike "Sena" wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
I'd say your best bet would be a Pivot Table Report.
Highlight your list, and goto Data - Pivot Table Report. You may need use the OPTIONS button to place your data in the correct place (i.e. drag it once in the "data" central area, and then again in the "colums" area - that way it will make colums out of your rows, but will group together similar codes and count them for you. Lemme know if it helps. -- Pierre Montreal "Mike H" wrote: Sena, Try this =SUM(1/COUNTIF(A1:A10,A1:A10)) Adjust to the size of your range then enter it with Ctrl+Shift+Enter Mike "Sena" wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Wonderful, it works ... Thanks !
-- Cheers ! "Mike H" wrote: Sena, Try this =SUM(1/COUNTIF(A1:A10,A1:A10)) Adjust to the size of your range then enter it with Ctrl+Shift+Enter Mike "Sena" wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
That's excellent news and thanks for the feedback.
"Sena" wrote: Wonderful, it works ... Thanks ! -- Cheers ! "Mike H" wrote: Sena, Try this =SUM(1/COUNTIF(A1:A10,A1:A10)) Adjust to the size of your range then enter it with Ctrl+Shift+Enter Mike "Sena" wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Hi,
Do the following: 1. Select a single cell on the top of the range. 2. On the Data menu, point to Filter, and then click the AutoFilter. 3. Click the arrow next to the cell and select the cell value to want to view. 4. Hightlight the value and you will see the Count value of the number of accurances in that cell value. Note: Right-click on the status bar and select Count before filtering the range. Challa Prabhu "Sena" wrote: I have a list of codes in a column, each code will be appearing many times. I need to count the number of codes - how do I do it. eg: A100 B100 A100 A100 B100 Number of codes in the above list are 2. Thanks -- Cheers ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |