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

5 Replies

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

Resources