Row Counter

L

Lionel B. Dyck

I'm creating a worksheet with numerous items (rows) in it. I need to have a
column that just indicates the row number relative to the first row (excluding
any titles).

Is there a way to do this?

thanks
 
R

Ragdyer

If you anticipate that you might insert and delete rows below your title
headers,
Here's one way:

If your data *starts* in Row4 (titles in Row3),
Enter this in Row4:

=ROW()-3

And copy down as needed.

Or, you could simply *double* click on the fill handle, and have this
formula *automatically* copied down the column, as far as there's data in
the adjoining column.
 
L

Lionel B. Dyck

Ragdyer said:
If you anticipate that you might insert and delete rows below your title
headers,
Here's one way:

If your data *starts* in Row4 (titles in Row3),
Enter this in Row4:

=ROW()-3

And copy down as needed.

Or, you could simply *double* click on the fill handle, and have this
formula *automatically* copied down the column, as far as there's data
in the adjoining column.
Click to expand...

Wow - I figured it would be something simple I had overlooked. Thanks
 
Top