Adding increment of 1

[Damian37]

Hello everyone,
I have a document that is a job tracker in which different people can go in to in order to add suggestions to the tracker. I would like to leave the initial A column blank until data is entered into any of the cells within the range of B:L. Currently I have added A1+1 within cell A2, but I would like to create a formula that would leave the A column blank until data is entered in to a new row within any of the cells in range B:L, and then add 1 to the number identified in the previous row within column A. Any help would be greatly appreciated. Thanks!!!

D.

 

[Damian37]

Can't imagine why, what Exactly do you have in A1 ?

A header label of #.

 

[jtakw]

So, what Exactly is

A header label of #.

We need to know Exactly what is in A1, and how it gets there ( manual input, by formula, import, etc. ).

 

[Damian37]

So, what Exactly is



We need to know Exactly what is in A1, and how it gets there ( manual input, by formula, import, etc. ).

It's a manual entry of "#" character to capture list of line numbers for tracker sheet. So A2 would have a manual entry of 1. I'm looking for a formula that will leave this column blank until data is entered within any cells of the columns B:L. Thank you very much for your assistance!

Cheers!!!!

D.

 

[jtakw]

If your First numeric entry is in A2, then you need to put the formula in A3 copied down, and change the range reference starting at row 3, like below:

=IF(COUNTA(B3:L3),A2+1,"")

or

=IF(COUNTA(B3:L3)=0,"",A2+1)