Forum Discussion
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 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 :)
12 Replies
- 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.
