Nonsequential column numbering
 

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!


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=469276

Nonsequential column numbering
 

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 ,
dziw 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?