Hi All,

I'm basically trying to add a number in the column next to a list, but so that each value in the list has it's own numbering. Example:

A 1
B 1
C 1
B 2
B 3
C 2
A 2
B 4
C 3
A 3

Basically the numbers on the right are numbering the occurrences of A, B and C independently.

I tried using the MATCH function to do this, but I've only been able to get sequential numbers in column B...

This is what I've used:
=MATCH(Table1[[#This Row],[ColumnA]],[ColumnA])

Thanks for your help!