1234

1234

1234

I need this changed by adding "A" "B" etc for example :

1234 - A

1234 - B

1234 - C

etc

1234 - AA

1234 - AB

etc.

any solution for this

- Thread starter villival
- Start date

1234

1234

1234

I need this changed by adding "A" "B" etc for example :

1234 - A

1234 - B

1234 - C

etc

1234 - AA

1234 - AB

etc.

any solution for this

Thannks for this...

1234

1234

1234

I need this changed by adding "A" "B" etc for example :

1234 - A

1234 - B

1234 - C

etc

1234 - AA

1234 - AB

etc.

any solution for this

Code:

`=A2 & IF(COUNTIF($A$2:$A$3000,A2)>1," - " & MID(CELL("address",INDEX(1:1,COUNTIF(A$2:A2,$A2))),2,FIND("$",CELL("address",INDEX(1:1,COUNTIF(A$2:A2,$A2))),2)-2),"")`

If you have Office 365 this can be shortened a bit to:

Code:

`=LET(a,A2, b,$1:$1,c,A$2:A2,d,CELL("address",INDEX(b,COUNTIF(c,a))),a & IF(COUNTIF($A$2:$A$3000,a)>1," - " & MID(d,2,FIND("$",d,2)-2),""))`

The formulae above do not add any suffix if there is only one instance of a number.

If you're interested this could be converted to a lambda formula (Office 365 only) which could look something like:

=SUFFIX(A2,A$2:A$3000)

(

Come back if you are.

Excellent!Another option, formula in cell B2 for letter from A to XFD

How did I forget about ADDRESS when I remembered CELL("address"… ?