Column cells enumerating

**CESAR V. ARROYO** · 07-18-2009, 05:31 AM

I need to enumerate the cells in a column with consecutive numbers, that is: 1,2,3, etc. The range involves blank cells. In short, when "g1" is active, "e1" equals "1"; when "g2" is active,
"e2" equals "2"; and so on; then when column "g" happens to be inactive, column "e" becomes empty. So forth so good.

Up to this stage this is my formula:
=if(g54>"",sum(e53+1),"")

i didn't realized that i was going to get empty cells. So my formula has limitations. Thus i need a formula that enumerates the cells in column "e" depending on the status of column "g" in such a way that when a cell in column "g" happens to be inactive, and consequently column "e" becomes empty, the formula reads and sums the value in the last active cell in column "e" to the cell right after the same empty cell in column "e" so the serie follows a logical secuence.

Any help will be greatly appreciated.

**JBeaucaire** · 07-18-2009, 05:59 AM

In E1:
=IF(G1 = "", "", 1)

In E2 and then copied down:
=IF(G2 = "", "", MAX($E$1:$E1)+1)

**mrice** · 07-18-2009, 06:01 AM

Try pasting this formula into E1 and copy down.

=IF(G1="","",COUNTA(G$1:G1))

**CESAR V. ARROYO** · 07-19-2009, 01:30 PM

Originally Posted by jbeaucaire

in e1:
=if(g1 = "", "", 1)

in e2 and then copied down:
=if(g2 = "", "", max($e$1:$e1)+1)

thank you jb, it really works as i need it to. I'll catch you later.

**CESAR V. ARROYO** · 07-19-2009, 01:32 PM

Originally Posted by mrice

try pasting this formula into e1 and copy down.

=if(g1="","",counta(g$1:g1))

thank you martin, it does the job. I really appreciate your help. Talk to you soon.

**JBeaucaire** · 07-19-2009, 02:44 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)