Forum Discussion
How to fill a column with sequential numbers when some rows need to be skipped
I am trying to automate a process whereby I fill a column with a linear series of numbers with a step value of 1. The challenge is that not all rows qualify to receive a number. (The rows represent ...
Let's say that you want to skip a row if column A is blank. In C3:
=IF(A3="","",MAX(C$2:C2)+1)
Fill down.