sub-label column

[skitols]

I am trying to create a field of sub-labels. I have a column labeled with numbers, but many repeat. See below:

1
1
2
2
2
3
4
4
4
4
5
etc......

And I am trying to create a column where I can uniquely identify these numbers. See below:
1A
1B
2A
2B
2C
3A
4A
4B
4C
4D
5A
etc.....

Does anyone know a Macro or anyway I can create these letters inside of a column, relating to the numbers?

Thanks a lot!

[sweep]

OK,

Presuming your data starts at A1, fill in B1 manually (in your example type in 1A), then in B2 enter this

=IF(A2=A1,A2&INDEX({"B","C","D","E","F","G","H"},MATCH(RIGHT(B1,1),{"A","B","C","D","E","F","G"},1)),A2&"A")

and copy it down your data.

Extend the range of letters as you require

[DonkeyOte]

Another slight variant of that could be:

B1: =A1&INDEX({"A","B","C","D","E"},COUNTIF($A$1:$A1,$A1))
copied down

You would need to ensure if using letters etc that your INDEX includes the necessary amount of options... create them in a list and refer to it in the INDEX ... you could also use Cell address info rather than creating a list but then the function would become volatile (bad).