Apr 17 2019 07:29 PM
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 for the next unique shot # read. Every shot # on any given date will have the same ID.
This then needs to apply to ID2 but based on the Product adjacent to the shot/date.
The below table is how I would like to ID's to read, I just need the ID's to generate themselves rather than be populated by manual input...
Date | ID1 | Shot # | ID2 | Product |
1/04/2019 | 1 | ABC | 1 | 100200 |
1/04/2019 | 1 | ABC | 1 | 100200 |
1/04/2019 | 2 | DEF | 1 | 100200 |
1/04/2019 | 2 | DEF | 2 | 300400 |
1/04/2019 | 1 | ABC | 2 | 200100 |
2/04/2019 | 1 | ABC | 1 | 200200 |
2/04/2019 | 2 | GHI | 1 | 200200 |
2/04/2019 | 2 | GHI | 2 | 400500 |
2/04/2019 | 3 | DEF | 1 | 200200 |
2/04/2019 | 1 | ABC | 2 | 300400 |
Thank you :)