cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-449305%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20formula%20which%20creates%20A1%2CA2%2CA3%20when%20identical%20SKU%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449305%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3ECan%20a%20expert%20help%20with%20this%3F%3C%2FP%3E%3CP%3EBR%2FClauP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-449305%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-449435%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20a%20formula%20which%20creates%20A1%2CA2%2CA3%20when%20identical%20SKU%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F264624%22%20target%3D%22_blank%22%3E%40ClauP%3C%2FA%3E%26nbsp%3B%2C%20unfortunately%20your%20file%20is%20not%20downloadable%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-449452%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20a%20formula%20which%20creates%20A1%2CA2%2CA3%20when%20identical%20SKU%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F264624%22%20target%3D%22_blank%22%3E%40ClauP%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggest%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3DIF(COUNTIF(%24A%242%3A%24A%248%2CA2)%26gt%3B1%2CA2%26amp%3B%22A%22%26amp%3BCOUNTIF(%24A%242%3AA2%2CA2)%2CA2)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20it%20in%20the%20attached%20file%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E
ClauP
ClauP
Occasional Contributor

‎04-13-2019 12:29 AM

‎04-13-2019 12:29 AM

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

 

Labels:
362 Views
0 Likes
2 Replies
Reply
2 Replies
Sergei Baklan

‎04-13-2019 02:25 AM

‎04-13-2019 02:25 AM

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

@ClauP , unfortunately your file is not downloadable

0 Likes
Reply
Highlighted
Haytham Amairah

‎04-13-2019 02:37 AM

‎04-13-2019 02:37 AM

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

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

0 Likes
Reply
Related Conversations
Tabs and Dark Mode
 cjc2112 in Discussions on 09-18-2019
46 Replies
flashing a white screen while open new tab
 Deleted in Discussions on 10-05-2019
14 Replies
Stable version of Edge insider browser
 HotCakeX in Discussions on 10-12-2019
35 Replies
Extentions Synchronization
 Deleted in Discussions on 11-13-2019
3 Replies
Security Community Webinars
 Valon_Kolica in Security, Privacy & Compliance on 10-22-2019
13 Replies
How to Prevent Teams from Auto-Launch
 chenrylee in Microsoft Teams on 06-27-2019
30 Replies