Cell knows its position in a list?

[Lou Sander]

I have a 600+ row list in Excel 2003. As I use it, it gets sorted in several different ways, depending on my needs at the moment.

In each record, I'd like to have a cell that displays the record's current position in the list. The top item would be 1, the second would be 2, etc.

It's basically a record number indicator, but the record number of a given row varies depending on the most recent sort.

It seems as though this should be easy, but I haven't figured out how to do it.

[sdckapr]

you could use a formula:
=row()
or (depending on setup. for example with a header row)
= row()-1

Steve