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
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