Home

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

ClauP
Occasional Contributor
2 Replies

@ClauP , unfortunately your file is not downloadable

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies