Forum Discussion
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 ...
=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.
- 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?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.
