ClauPCopper ContributorApr 13, 2019How to create a formula which creates A1,A2,A3 when identical SKU in a columnHelloCan a expert help with this?BR/ClauP How to create formula A1,A2 when identical SKU.xlsx9 KB
2 RepliesReplies sorted by NewestHaytham AmairahSilver ContributorApr 13, 2019Hi 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,HaythamHow to create formula A1,A2 when identical SKU (Solved).xlsx10 KBSergeiBaklanDiamond ContributorApr 13, 2019ClauP , unfortunately your file is not downloadable
Haytham AmairahSilver ContributorApr 13, 2019Hi 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,HaythamHow to create formula A1,A2 when identical SKU (Solved).xlsx10 KB
