LIST FORMULA HELP.xlsx

Hi,

I have been messing around with INDEX, MATCH, COUNTIF, VLOOKUP but I can't seem to get it right.

On the sample I would like to label in "C:C" the occurance of the variable in order in "B:B" against the individual listed in "A:A".

i.e. C2 (TOM)="A" C5 (TOM)="B" C9 (GARY) ="A"

can anyone help?

many thanks!