Results 1 to 5 of 5

How to sort from highest to lowest

Threaded View

  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.

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. [SOLVED] 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