How to delete duplicates and also count them

[Eddie]

I'm in dire need of help

I have a column of 2500 entries that account for no more than 10 duplicates.

So I know there has to be at least 250 unique entries. I'd like to
account for every item but I don't want to have the duplicates listed.

So Column A might look like this:

a
a
a
a
a
a
b
b
c
c
c
c
d
d
d

I'd ultimately want col a to just have

a
b
c
d

and then col b have how many times that instance showed up

a - 6
b - 2

etc
etc

 

[Eddie]

Mike,

Thanks so much for the reply.

I did the first part in that I got a list of the items without duplication.
I'd like to now count how many times those showed up on the original list.

I got sort of lost in the second part of your reply.

 

[Mike H]

Hi,

You now have a filtered list of unique items starting in (say) C2 and your
original data are in column A starting in A2.

Put the formula I gave you in D2 and it will count the instances of the
value in C2. Drag the formula down as long as the list in column C

Mike

 

[Eddie]

That worked excellent.

Thanks again for your help.