Count IF based on occurence

[dw700d]

I would like to create a formula that counts how often a code appears in the Code column below. So for example the first row in the Count column would return a value of 3 because code "C123" appears three times in the code column and row 4 of the count column would return a value of 1 because "D34" appears once in the code column

Count	Code
3	C123
3	C123
3	C123
1	D34
1	F84
1	W11
2	R56
2	R56
1	F25
2	G11
2	G11

[#2 · Accepted solution]

@dw700d 

Let's say the codes are in B2:B12.

Enter the following formula in A2:

=COUNTIF($B$2:$B$12,B2)

and fill or copy down to A12.