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))
 
Top