Count based on criteria

[Blessy Clara]

Hi All,

I have a AC_ID in column A, which contains multiple records for a given AC_ID, I need help to count the number of records per ID

Example[TABLE="width: 500"]
<tbody>[TR]
[TD]AC_ID[/TD]
[TD]Records[/TD]
[/TR]
[TR]
[TD]256[/TD]
[TD]Record1[/TD]
[/TR]
[TR]
[TD]256[/TD]
[TD]Record2[/TD]
[/TR]
[TR]
[TD]256[/TD]
[TD]Record3[/TD]
[/TR]
[TR]
[TD]40435[/TD]
[TD]Record4[/TD]
[/TR]
[TR]
[TD]40435[/TD]
[TD]Record5[/TD]
[/TR]
[TR]
[TD]40435[/TD]
[TD]Record6[/TD]
[/TR]
[TR]
[TD]5208[/TD]
[TD]Record7[/TD]
[/TR]
[TR]
[TD]362[/TD]
[TD]Record8[/TD]
[/TR]
[TR]
[TD]362[/TD]
[TD]Record9[/TD]
[/TR]
</tbody>[/TABLE]

I require a table calculated as this
[TABLE="width: 500"]
<tbody>[TR]
[TD]AC_ID[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]40435[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5208[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]362[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1487[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]5489[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]256[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

To calculate Number of records per ID Number


Thank you

 

[Scott T]

Book1
	A	B
1	AC_ID	Records
2	256	Record1
3	256	Record2
4	256	Record3
5	40435	Record4
6	40435	Record5
7	40435	Record6
8	5208	Record7
9	362	Record8
10	362	Record9
11
12
13
14
15	AC_ID	Count
16	40435	3
17	5208	1
18	362	2
19	1487	0
20	5489	0
21	256	3
Sheet1

Cell Formulas
Range	Formula
B16	=COUNTIF($A$2:$A$10,A16)
B17	=COUNTIF($A$2:$A$10,A17)
B18	=COUNTIF($A$2:$A$10,A18)
B19	=COUNTIF($A$2:$A$10,A19)
B20	=COUNTIF($A$2:$A$10,A20)
B21	=COUNTIF($A$2:$A$10,A21)