Results 1 to 2 of 2
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Cell knows its position in a list?

    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.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    you could use a formula:
    =row()
    or (depending on setup. for example with a header row)
    = row()-1

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    Lou Sander (2011-02-10)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •