Row Counter

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

--
Lionel B. Dyck <><
AIM ID: lbdyck
Homepage http://www.lbdsoftware.com

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lionel B. Dyck" <x-lbdyck@ca.astound.net-x> wrote in message
news:eHZP8$ytGHA.3964@TK2MSFTNGP04.phx.gbl...
> 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
>
> --
> Lionel B. Dyck <><
> AIM ID: lbdyck
> Homepage http://www.lbdsoftware.com

Ragdyer wrote:
> 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.

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

--
Lionel B. Dyck <><
AIM ID: lbdyck
Homepage http://www.lbdsoftware.com