Count duplicates and put their number in next column

Hello,

I have a very large wordlist in excel which looks like:

Column.A
love
love
life
store
who
zebra
love
store

Now I would like to have the number of frequency of each word in Column B. For example the word "love" is three times there and the word "store" two times. I need it to look like:

Column.A------------Column.B
love-------------------3
love-------------------3
life---------------------1
store------------------2
who-------------------1
zebra-----------------1
love-------------------3
store------------------2

Thank you for ur help in advance.