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,
Bookmarks