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,...
Assuming your data is in A:A, I would create a helper column to track new occurrences. In B1, try =IF(COUNTIF($A$1:$A1,A1)=1,A1,""), then in C1, =FILTER(Z:Z,Z:Z<>"").
B column will list every new code, then the formula in C will filter out all the unneeded blanks.
If you just want the last digit, create a second column using =RIGHT(A1,1) and drag down.