Labelling multiple occurances of variable in larger list

[cloudwalking]

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!

[Pete_UK]

It might be better to label them with numbers, otherwise you will run out of letters after "Z". Put this in C1:

=IF(B1="x",SUMPRODUCT((A$1:A1=A1)*(B$1:B1="x")),"")

then copy down.

Hope this helps.

Pete

EDIT: If you really want letters, then you can use this in C1:

=IF(B1="x",CHAR(SUMPRODUCT((A$1:A1=A1)*(B$1:B1="x"))+64),"")

then copy down.

Pete

[cloudwalking]

THat's great thanks!

[Pete_UK]

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Pete