Forum Discussion

Copper Contributor

Apr 13, 2019

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

Hello Can a expert help with this? BR/ClauP

Silver Contributor

Apr 13, 2019

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