How to create a formula which creates A1,A2,A3 when identical SKU in a column

[ClauP]

Hello

Can a expert help with this?

BR/ClauP

[#2]

@ClauP , unfortunately your file is not downloadable

[#3]

Hi @ClauP,

I suggest this formula:

=IF(COUNTIF($A$2:$A$8,A2)>1,A2&"A"&COUNTIF($A$2:A2,A2),A2)

Please find it in the attached file as well.

Regards,

Haytham