Creating ID based on numerous cell content

Occasional Contributor

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

 

DateID1Shot #ID2Product
1/04/20191ABC1100200
1/04/20191ABC1100200
1/04/20192DEF1100200
1/04/20192DEF2300400
1/04/20191ABC2200100
2/04/20191ABC1200200
2/04/20192GHI1200200
2/04/20192GHI2400500
2/04/20193DEF1200200
2/04/20191ABC2300400

 

Thank you :)

 

@Twifoo

@Sergei Baklan 

 

0 Replies