VBA Code

[MichaelJ300]

Hello,

I'm looking for some code that will rank by name. Meaning anytime a name changes it will start over counting. Please see below.

Name Rank
Frank 1
Frank 2
Frank 3
Frank 4
Mark 1
Mark 2
Mark 3
Mark 4
Mark 5
Mark 6
Mike 1
Mike 2
Mike 3

Thanks in advance!

 

[Joe4]

No VBA code necessary. This can be done easily with just a formula.
Place this in cell B2 and copy down:

=IF(A2=A1,B1+1,1)

 

[MichaelJ300]

SMH... Thank you I totally over thought this

 

[Joe4]

You are welcome!