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

AC_ID	Records
256	Record1
256	Record2
256	Record3
40435	Record4
40435	Record5
40435	Record6
5208	Record7
362	Record8
362	Record9

<tbody>
</tbody>

I require a table calculated as this

AC_ID	Count
40435	3
5208	1
362	2
1487	8
5489	85
256	3

<tbody>
</tbody>

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)