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...
Thank you :)