# WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

Copper Contributor

# WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

So I have a table, and when I fill out one column,

I would like the column to the left of it to automatically show a number

starting with 1, then 2, then 3, then 4, etc.

so every time I fill a row in that one column,

the column to the left will automatically show the number of that row that was filled

So Row one column one will say 1 when I fill out Row one column two.

Row two Column one will say 2 when I fill out Row two column two.

Row three column one will say 3 when I fill out Row three column two.

3 Replies

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

=IF(NOT(ISBLANK(B1)),ROW(),"")
=IF(B1<>"",ROW(),"")

In my sheet i can enter one of these formulas in row one of column one and fill it down as required. Then in column one the row number is returned if the adjacent cell in column two isn't blank.

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

If I do the first one, column one says 12
if I do the second one, row one says 0

But I'd like it to say "1"

Am I supposed to add anything to the formula you gave?

B1 would be column 2 row 1 correct?

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

Yes, B1 is column 2 row 1. Both formulas return the intended result in my sheet.

=IF(NOT(ISBLANK(B1)),ROW(),"")

This is the formula which is in cell A1 and filled down. In the screenshot is the german formula since i work with german Excel.

=IF(B1<>"",ROW(),"")

This is the other formula which is in cell A1 and filled down with the same result.