PDA

View Full Version : next number in column



ads_3131
06-14-2012, 05:01 AM
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
06-14-2012, 06:34 AM
I am really not sure what you are asking, but maybe this will help you...

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

Bob Phillips
06-14-2012, 07:23 AM
Try


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