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

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Apr 23, 2019

        In the attached file, the formula for ID1 in B2, copied down rows, is: 

        =IF($A2<>$A1,1,
        IFERROR(LOOKUP(2,1/(($A$1:$A1=$A2)*($C$1:$C1=$C2)),$B$1:$B1),
        LOOKUP(2,1/($A$1:$A1=$A2),$B$1:$B1)+1))

        Conversely, the formula for ID2 in D2, copied down rows, is: 

        =IF($A2<>$A1,1,
        IFERROR(LOOKUP(2,1/(($A$1:$A1=$A2)*($C$1:$C1=$C2)*($E$1:$E1=$E2)),$D$1:$D1),
        IFERROR(LOOKUP(2,1/(($A$1:$A1=$A2)*($C$1:$C1=C2)),$D$1:$D1)+1,1)))

Resources