cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
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 
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:
168 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
How to Prevent Teams from Auto-Launch
 chenrylee in Microsoft Teams on 06-27-2019
28 Replies
Tabs and Dark Mode
 cjc2112 in Discussions on 09-18-2019
2 Replies
Early preview of Microsoft Edge group policies
 Sean Lyndersay in Discussions on 06-14-2019
65 Replies
How to download windows server 2019 update to 1903
 Cmakar37 in Windows Server for IT Pro on 07-03-2019
5 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
 Elliot Kirk in Articles on 05-01-2019
204 Replies
$cred = Get-Credential without asking for prompts in powershell
 TejCGS in Office 365 on 04-25-2019
6 Replies