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.