numbering rows

[Meg]

I'm using excel 2002 and I want to add an additional column that counts the
rows. I have created it and numbered it, but when ever I do a sort, the
numbers get sorted and they are out of order. Is there a way to keep them
in order while sorting?

Thanks

 

[darrenmcconachie]

use the formula =row() instead of hard-coding the number

Darren

 

[Meg]

great, thanks
but how can I get row 2 to be number 1 ( I have a header row)

 

[John Forrest]

Just subtract by 1. So it would look like this: =row()-1

 

[Meg]

You rock!!
Thanks!