Forum Discussion

luism95's avatar
luism95
Copper Contributor
Jul 26, 2019
Solved

create unique setup code

excel
Formulas and Functions
Macros and VBA
  • tauqeeracma's avatar
    tauqeeracma
    Jul 29, 2019

    Hi luism95,  formula for setup code in 'Single Layer Coding Matrix' sheet is automated now.

     

    I have added one new sheet 'Setup Code' where code combination is managed. You just need to review and verify the values appearing in  column P of this sheet.

     

    Hope it will fulfill your requirements.

    Thanks,

    Tauqeer

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Jul 27, 2019

luism95 

You need to share your data in excel format. Also please explain the break down (formation) of desired 'Setup Code' as below:

Thanks

luism95's avatar
luism95
Copper Contributor
Jul 29, 2019

tauqeeracma 

 

Is there a way to attach the excel file? Or how do I share the data in excel format? The 2nd image shows where I'm getting the information from and the first is formatting it into the setup code.  The last code in the first image is the combination from the second. Hopefully that helps. It's a bit difficult to explain. 

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Jul 29, 2019

    luism95 

    While replying, please use below icon to attach your excel file.

     

Resources