Counting duplicates

[nguindon]

Hello, I have a list of contact information which has a very large number of duplications. I was able to filter it down to unique values, but I've been asked to add a column which states the number of times each entry was repeated in the original list. We want this (each character is a column):

aa
aa
aa
az
bb
bx
cc
cc
cc
dd

to turn into:
aa3
az1
bb1
bx1
cc3
dd1

If someone could help me with this I would be eternally grateful!

 

[Aladin Akyurek]

Have you considered running a pivot table on the original data?

 

[nguindon]

I considered it but decided not to because I had no idea what I was doing

 

[Aladin Akyurek]

I considered it but decided not to because I had no idea what I was doing

Let A2:A11 house the letter codes.

Let E2:E7 house the unique codes.

In F2 enter and copy down:

=COUNTIF($A$2:$A$11,$E2)