Unique-Code-Generate

[majidsiddique]

Hi all,
i need you help to solve this issue. i am working to create a unique code by color and size criteria column E and F. column A i want code by formula and manually i type column B. first check color then size to make a code.

please see the excel file.

Thanks.

[AliGW]

This will get you the unique codes you need (although not quite in the format you specified):

=D2&"-"&LEFT(C2,2)&"-"&COUNTIFS(C$2:C2,C2,D$2:D2,D2)

Should work for your needs.

[majidsiddique]

Its really perfect AliGW,
but in the middle short form reflect the column C ( short form )

[AliGW]

Yes, I know, however you are making it unnecessarily complex. Unless you add a column where you give the short form you want to use, and then use that in your code, you are going to need a very complicated formula, because you are not using the same logic for all items.

At the end of the day, you need a unique code, and that's what my formula provides. Unfortunately I don't have time today to help further with this.

[majidsiddique]

Agreed, Thanks