Nonsequential column numbering

[dziw]

I have a spreadsheet that needs numbers in the far left column to track row data. Some rows have data, while others are skipped. I need to be able to number the rows sequentially without numbering empty rows. Any idea how? What if I need to insert a row - would the solution resequence?

Thanks!

[JE McGimpsey]

One way:

A1: 1
A2: =IF(COUNTA(B2:IV2),MAX($A$1:$A1)+1,"")

Copy A2 down as far as necessary.

If you inserted a row the solution would resequence. Is that what you
wanted?


In article <[email protected]>,
dziw <[email protected]> wrote:

> I have a spreadsheet that needs numbers in the far left column to track
> row data. Some rows have data, while others are skipped. I need to be
> able to number the rows sequentially _without_ numbering empty rows.
> Any idea how? What if I need to -insert - a row - would the solution
> resequence?