Nonsequential column numbering

  • Thread starter Thread starter dziw
  • Start date Start date
D

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!
 
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?
 
Back
Top