Adding Sequential Numbers in Column B Based on Column A Values

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!

Wow...thanks XOR LX! That was easy

EDIT: Sorry John, you got beat to the punch!

Originally Posted by habsfan1433

Wow...thanks XOR LX! That was easy

EDIT: Sorry John, you got beat to the punch!

Oh well, that's the breaks!!

Maybe:

Sub habsfan1433()
Dim x As Long
Dim y As Long
Dim z As Long
Dim i As Long
x = 0
y = 0
z = 0
For i = 2 To Range("A" & Rows.count).End(3)(1).Row
    Select Case Range("A" & i).Value
        Case Is = "A"
            x = x + 1
            Range("B" & i).Value = x
         Case Is = "B"
            y = y + 1
            Range("B" & i).Value = y
        Case Is = "C"
            z = z + 1
            Range("B" & i).Value = z
    End Select
Next i
End Sub

Originally Posted by XOR LX

"Beat to the punch"? "That's the breaks"?

I think my "North American" English needs some work!!

See. There's a lot more you can learn on this Forum than just Excel.