next number in column

[ads_3131]

Hello

How can i increment from the last digit in a column....? when theres rows blank..

example in same column row 1 has 3 , what formula would make 4 in row 7 based on another cell ...?

example

IF(ISTEXT(G3),1,"") - gives all the rows with text in Column G a 1 , but how can i build on this?

[CodeNinja]

I am really not sure what you are asking, but maybe this will help you...

cell E2: =IF(ISNUMBER(E1),E1 + 1, "")

[Bob Phillips]

Try


=IF(ISTEXT($G3),MAX($E$1:$E2)+1,"")