Forum Discussion
Continuing abnormal series in column
Hello, I am trying to continue an abnormal series. Generally, it is easy to click and drag to continue a series in the same column, but when I am trying to do the same technique with this series,...
Do you mean that you want to have a auto running number, from 001 to 999?
="EBL"& RIGHT("00"&(21+FLOOR.MATH((ROW(A1)-1)/(999*3))),2) & "-" &
RIGHT("000"& (MOD(INT((ROW(A1)-1)/3),999)+1),3) & "-" &
IF(MOD(ROW(A1),3)=1,"A",IF(MOD(ROW(A1),3)=2,"B","C"))
Note:
1) you may replace 999*3 with 2997
2) after row 2997, it will be EBL22-001-A, EBL22-001-B, EBL22-001-C, ...etc
3) copy and paste the formula to the row you need (after that, you may copy the cell and paste with text to fix the value)