+ Reply to Thread
Results 1 to 3 of 3

Sorting A Filter...Not keeping data the same

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    OHIO
    MS-Off Ver
    Excel 2007
    Posts
    7

    Sorting A Filter...Not keeping data the same

    Just a sheet I use for an online game, but something I started doing. When I use the stats sheet, if I want to say, sort by winners, or %, it will move data around, but doesn't sort properly. The data it moves also doesn't correspond to the appropriate line that it should be with. I assume it has to do with using the cell as a reference, other than direct text, but not 100% certain. What would be the best way to go about making that sort-able and keeping the data accurate?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Sorting A Filter...Not keeping data the same

    When I removed SheetName reference in formula for same sheet data, the sorting is working fine, e.g. Stats!A2 is used as A2. Please check and use, if it works for you.
    I am not sure of the reason behind this.
    If I have helped, click on the * below the post

  3. #3
    Registered User
    Join Date
    04-25-2011
    Location
    OHIO
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sorting A Filter...Not keeping data the same

    Simple enough fix. Hadn't thought about trying that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1