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!