fill series

Copper Contributor

I want to fill series in a column and skip those cell which has some values (text). and start Again from 1 in the next cell after text

2 Replies

Here is a simple way through a formula

Lets say that you have the values in column A




The logic is to check if you have any value in the same row. If there is something then leave blank

If the cell if empty then return what you had in the column with your numbering bigger by one.

The iferror is for the first row where you want to start the numbering. As you get an error by adding 1 to a text value, then just return 1.


If you want to have the original value and the subsequent numbers in the same column, then the formula would be something like




value in column A1st solution2nd solution


If on Excel 365

=SCAN(0, data, LAMBDA(a,v, IF(v="", N(a)+1, v ) ) )