Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort Issue (2000 sp3)

    Greetings!
    It has been a little while since my last post. Here is my issue. I have a Soccer tracking spreadsheet that I am using for a 4v4 Tourney. Basically, when I select the cells to sort based upon a certain column the first row does not sort to the proper spot.

    I select Cells B20 thru I27, Tab to I20 then sort in descending order. Row 20 data will not sort down to the proper order.

    Any Ideas?

    thanks,
    Brad

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sort Issue (2000 sp3)

    Hi Brad

    Make sure you select the "No header row" option at the bottom of the sort dialog box.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Issue (2000 sp3)

    Thanks,
    However, I am not using the sort dialog box. I am using the quick sort button which does not give me an option.

    Brad

  4. #4
    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

    Re: Sort Issue (2000 sp3)

    Make sure "No Header row" is chosen in the dialog.

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sort Issue (2000 sp3)

    In that case select the range B19 to I27 instead.

  6. #6
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Issue (2000 sp3)

    Thanks to all!

    Works like I expect
    Brad

Posting Permissions

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