Nonsequential column numbering

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!
 
J

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
convert columns to rows 6
Row numbering from a macro 0
Insert & Sequentially Number Column 9
Macro to re-number data 3
auto-numbering help (during inserting rows) 2
insert rows and copying cells in column b,c, and d into new rows 3
Row Numbering 8

Top