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