Autofill numbers in columns that contain empty cells

[MARIA.2NY]

Hello,

I have data in column A, C, E, G, and in lines 1-20, 25-36, 38-52.
How can I insert consecutive numbers on the left side of each cell containing data, since I can not use autofill as I have empty cells in some rows as well as empty cells in some columns?
Question 2: Can you use autofill starting at A1 and continuing for example in B7 or C15?
Question 2: Can you use autofill in a column, skipping the numbering when there is an empty cell?
Question 3: Am I making ANY sense AT ALL???

 

[Andrew Poulsom]

Put 1 in row 1 of the column you want to use (let's say H). Then in row 2 put something like this:

=IF(LEN(A2)>0,MAX(H$1:H1)+1,"")

and copy down.

 

[MARIA.2NY]

tHANK YOU, just did that and it is not skipping the empty cells. its just autofills the numbers as if i dragged the +symbol. I'll try again in case i did not copy right

 

[MARIA.2NY]

ok got it this time it worked. thanks. How can I continue in the next column?

 

[MARIA.2NY]

andrew what do i do if i want to skip two empty cells or three?

 

[Andrew Poulsom]

andrew what do i do if i want to skip two empty cells or three?

My formula skips any number of empty cells.