Need to know how to count number of repeated words in a list, with lots of different words

Hi,

So I need to cumulatively work out the number of times a word is repeated in a multi-word list.

E.g.

Bob
Jill
Bob
Bob
Jill
Frank
Bob
Frank

I would like code to produce the following numbers:

0
0
1
2
1
0
3
1

So that I can tell how many times each individual has been repeated.

I have been playing with COUNTIF and FREQUENCY etc. but to no avail.

All help appreciated. Thanks!

Use this:
=COUNTIF($A$15:A15,A15)-1

Lock the first cell in your range and drag down