Forum Discussion

El1-_321's avatar
El1-_321
Copper Contributor
Apr 18, 2019

Creating ID based on numerous cell content

Hiya,   Does anyone know how to generate a running ID (being 1, 2, 3 etc) based on column information?   I need ID1 to read 1 for the first Shot # read according to the date (01/04/2019). Then 2 ...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Apr 18, 2019
It seems that ID2 for Product 200100 on 1/04/2019 and Product 300400 on 2/04/2019 should be 3 instead of 2. Please clarify.
El1-_321's avatar
El1-_321
Copper Contributor
Apr 18, 2019

Twifoo 

 

Hi, ID2 is unique to ID1 & the date. So 200100 is the second product adjacent to ABC on the 01/04/2019 as is 300400 on the 02/04/2018

  • El1-_321's avatar
    El1-_321
    Copper Contributor
    Apr 22, 2019

    Hi Twifoo does my response make sense? 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Apr 22, 2019
      I will study the logic of the needed formulas, especially ID2.
      • El1-_321's avatar
        El1-_321
        Copper Contributor
        Apr 22, 2019

        Thank you!! Twifoo 

Resources