+ Reply to Thread
Results 1 to 5 of 5

How to sort from highest to lowest

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    boca raton florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to sort from highest to lowest

    This question must have a simple solution, but I cannot find it in Microsoft help or elsewhere online. I gather data on patients in a pain clinic where they rate pain severity on 0 to 10 rating scale for 10 different body areas.

    My most recent data set looks like this, with the body area in column A and the patient rating in Column B. Column C is the average rating for a large normative group. I want to resort the data according to Column B, so that the rows are rearranged in descending order to show the body area with the highest pain rating at the top, followed by the next highest body area, and so on.

    Area Pt rating Avg
    ABDOMEN 7 3
    ARMS/HANDS 3 0
    CHEST 5 4
    GENITAL AREA 0 1
    HEAD 0 0
    JAW/FACE 0 0
    LEGS/FEET 9 4
    LOWER BACK 9 8
    MIDDLE BACK 0 0
    NECK/SHOULDERS 0 5

    I would like the resulting re-ordering of the data to look like this:

    LEGS/FEET 9 4
    LOWER BACK 9 8
    ABDOMEN 7 3
    CHEST 5 4
    ARMS/HANDS 3 0
    HEAD 0 0
    JAW/FACE 0 0
    MIDDLE BACK 0 0
    NECK/SHOULDERS 0 5

    The goal is to sort according to Column B, and have the associated values in Columns A and C to stay matched with Column B.

    Could someone help me do this? The sort button in excel doesn't seem to do this for me. It seems to rearrange column B and leave Column A and C values in place.
    Thanks,
    Last edited by dneunabe; 11-22-2013 at 12:27 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: How to sort from highest to lowest

    All three columns must be selected. Sort, Custom, Column B
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-22-2013
    Location
    boca raton florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to sort from highest to lowest

    I'm not sure what you mean. I don't get a "custom" option when I use the "sort" command. Could you expound?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to sort from highest to lowest

    OP is using 2003, which does not have that option

    Just highlight range, select Data/Sort (it should default to "header row" being checked). Under "sort by", select PT, select Descending - sort
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    11-22-2013
    Location
    boca raton florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to sort from highest to lowest

    Thanks,
    I had to copy the data into a blank section of the spreadsheet-- perhaps the sort function did not like formulas being in some of the cells. It worked perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MACRO to sort columns by highest value to lowest
    By cjhiggins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2013, 02:31 AM
  2. how to sort time lowest to highest
    By Auzzie_Dazza in forum Excel General
    Replies: 1
    Last Post: 03-31-2012, 09:40 AM
  3. How do I sort ascend from highest to lowest
    By JennyC in forum Excel General
    Replies: 1
    Last Post: 08-08-2006, 08:25 PM
  4. [SOLVED] How do I sort ascend from highest to lowest
    By JennyC in forum Excel General
    Replies: 0
    Last Post: 08-08-2006, 07:45 PM
  5. [SOLVED] Sort from lowest to highest
    By Steved in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2005, 08:07 PM

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