Adding values in collumn disconsidering blanks

[Ramos12]

Hi all,

Please consider the table below. Is there a way do automatically set the order ignoring blanks?


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Value[/TD]
[TD]Order[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

 

[ruimarto]

Hi,

That's a really tough one m8.

Try pasting the formula below in cell B1 and dragging down.

=IF(A1="","",COUNTA($A$1:A1))