Hello there!
My organization tracks a number of different items via excel, and sorts them by number of incidents per month. I'm trying to build an variable item number, next to a column of timestamps (making use of the NOW()) function.
It might look a bit like this, as an example
5/09/2020 MAY001
5/13/2020 MAY002
5/19/2020 MAY003
5/30/2020 MAY004
6/1/2020 JUN001
6/23/2020 JUN002
7/6/2020 JUL001
7/14/2020 JUL002
I hope the above pattern helps clue my goal. In building the latter number (MAY001), I'm struggling on two fronts. First of all, the incrementation:
=TEXT(NOW(),"mmm") & "001"
I need to figure out how to change & "001" into a formula that increments on each new row. Then, that increment must reset again at the end/beginning of the month, and a new prefix substituted in.
Any ideas on how to proceed? Thanks for any assistance!
My organization tracks a number of different items via excel, and sorts them by number of incidents per month. I'm trying to build an variable item number, next to a column of timestamps (making use of the NOW()) function.
It might look a bit like this, as an example
5/09/2020 MAY001
5/13/2020 MAY002
5/19/2020 MAY003
5/30/2020 MAY004
6/1/2020 JUN001
6/23/2020 JUN002
7/6/2020 JUL001
7/14/2020 JUL002
I hope the above pattern helps clue my goal. In building the latter number (MAY001), I'm struggling on two fronts. First of all, the incrementation:
=TEXT(NOW(),"mmm") & "001"
I need to figure out how to change & "001" into a formula that increments on each new row. Then, that increment must reset again at the end/beginning of the month, and a new prefix substituted in.
Any ideas on how to proceed? Thanks for any assistance!