I am in need of assigning a re-occurring number sequence to a large data set, based on cell value.
A small sample of the data set shows below, in column A:
I need to generate a re-occurring number sequence in column B, like showing below:
So in column A, for every entry of AX1002, the...