All,
I have the Excel Table, that I want it to generate a unique ID for each new row.
However I have 2 types of entries in the spreadsheet CR= "Change Request" EW = "Early Warning" (Project Management Terms).
This will be a drop down selection in Column A
Column B - Here I want to work out what was chosen in Column A and then add the next sequential number for either CR or EW
So image of below is what I would like to achieve.
snip.png
Bookmarks