numbering rows

N

Nancy

I know this is a simple thing, but I want a column that
starts my worksheet that numbers my rows.

Would appreciate step by step instructions...............

thanks..........Nancy
 
A

Arvi Laanemets

Hi

Without headers, and key values (always non-empty when the row isn't empty)
in column B
into A1 enter the formula
=IF(B1="","",ROW(A1))

The same with headers in row 1
=IF(B2="","",ROW(A2)-ROW(A$1))

The same as above, but the numbering is continous, when there are empty rows
in datarange
=IF(AND(B2="",A3=""),"",ROW(A2)-ROW(A$1))
 

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

change array to simple columns 7
How do I get rid of a series of hyperlinks in a column or row 4
A macro to hide rows 5
hide, unhide column or row after protect worksheet 4
Missing row numbers 3
Add Row to end of Table with a Macro Button 7
Making a specific row number active from a cell entry 15
Macro to copy & paste-special-values data to selected worksheets 1

Top