Hi,

I have been trying to increment cells with the same letter combination with no success. I have different letter initials and I want to make sure that cells with the same letters have sequential numbers and that if a cell has a different letter combination it starts with 1 and then increments cells with the same combination. Any ideas?

Here is an example of what I am trying to do:

OH-1
FN-1
OH-2
CK-1
FN-2
CK-2
CK-3

Thank you!