Assign Ascending Letters to Matching Numbers (Eliminate Duplicates)

[adamp1027]

Hello,
I have a list of sku numbers in column A (example N02345, LN0345)
I need to assign a, b, c, etc to the end when the sku appears more than once.

I found some possible solutions in another thread, but they don't work.
Maybe because my sku numbers start with letters?

=A2&CHAR(64+COUNTIF(A$2:A2,A2))
=A2&LOOKUP(COUNTIF($A$2:A2,A2),{1,2,3,4,5},{"A","B","C","D","#"})

 

[StephenCrump]

Perhaps:

=A2&IF(COUNTIF(A$2:A2,A2)=1,"",CHAR(63+COUNTIF(A$2:A2,A2)))

Do you need to allow for the possibility of more than 26 duplicates?

 

[BSALV]

with A the offset is 64, with a 96

Map1
	A	B
2	LN0345	LN0345A
3	LN0345	LN0345B
4	LN0345	LN0345C
5	N02345	N02345A
6	N02345	N02345B
7	N02345	N02345C
8	LN0345	LN0345D
9	LN0345	LN0345E
10	LN0345	LN0345F
11	N02345	N02345D
12	N02345	N02345E
13	N02345	N02345F
14	N02345	N02345G
15	N02345	N02345H
16	LN0345	LN0345G
17	LN0345	LN0345H
18	LN0345	LN0345I
19	LN0345	LN0345J
20	LN0345	LN0345K
21	LN0345	LN0345L
22	LN0345	LN0345M
23	LN0345	LN0345N
24	LN0345	LN0345O
25	LN0345	LN0345P
26	LN0345	LN0345Q
Blad2

Cell Formulas
Range	Formula
B2:B26	B2	=IF(A2="","",A2&CHAR(64+COUNTIF($A$2:A2,A2)))

 

[adamp1027]

Thanks! Stephen yours seemed to not add the letter after, but BSALV's solution works perfectly.