Rank and Sort

[watermt]

I'm trying to sort the list below based upon the results displayed in the
last two columns. I tried to sort the data but it did not display what I was
looking for. I need them ranked (sorted) so that the lowest percentage in
column G and the lowest percentage in column H are ranked first.


A B C D E F G
H
1 53% 64% 48% 74 74 100% 55%
2 75% 81% 69% 74 74 100% 75%
3 51% 66% 62% 74 46 62% 60%
4 61% 0% 35% 74 36 48% 32%
5 47% 50% 58% 74 17 22% 52%
6 69% 83% 70% 74 74 100% 74%
7 58% 86% 69% 74 62 83% 71%
8 0% 0% 0% 74 0 0% 0%
9 66% 82% 72% 74 74 73% 73%
10 68% 81% 64% 74 69 93% 71%

Any help is much appreciated,
Mike

 

[Shane Devenshire]

Hi,

when I copy your data I get only A:G. When I sort on the last column in
ascending order and then on the next to last column in ascending order I get
the lowest item first for both columns. But that is pure chance. I am
assuming you want all the other columns to sort with these last two? If so
the second lowest item in the last column is on the same row as the third
lowest item in the next to last column and there is no way these two items
can be on the same line if all the data is sorted together.

 

[Shane Devenshire]

Hi,

when I copy your data I get only A:G. When I sort on the last column in
ascending order and then on the next to last column in ascending order I get
the lowest item first for both columns. But that is pure chance. I am
assuming you want all the other columns to sort with these last two? If so
the second lowest item in the last column is on the same row as the third
lowest item in the next to last column and there is no way these two items
can be on the same line if all the data is sorted together.

 

[watermt]

Shane,
Thanks for your reply! My aplogies in explaining this, actually under
column A are the numbers of the questions (1-10) and these are not the row
headings. I do want all columns to sort. I'm not following what you mean
by, "the second lowest item in the last column is on the same row as the
third lowest item in the next to last column"?

I'll try to explain this in a bit more detail, There were 74 surveys (Column
E) sent to staff with 10 questions (Column A)u. The surveys were sent to 3
sections or departments (Columns B, C and D)). Under each Section heading
(again Columns B, C, and D) are the results (%) of respondents answering each
question. The number of surveys returned (Column F) actually shows the
number of surveys answering each question in Column A. The % of surevys
returned that answered each question is in Column G. Column H is the average
percent of all 3 sections answering each question in Column A.

This was dumped in my lap orginally as a MSWord table and the person
responsible for this was having a hard time ranking the areas that need
attention as far as process improvements. What they need isQuestions ranked
in order by the last two columns. We can omit question 8 since there were no
answers provided, but the person I'm working with indicated that she felt the
number one priority is question 1 since 100% of those surveyed rersponded to
that question but it only generated a 55% in Column H.

I hope I've not mudded the water more than clearing it up,
Mike

 

[watermt]

Shane,
Thanks for your reply! My aplogies in explaining this, actually under
column A are the numbers of the questions (1-10) and these are not the row
headings. I do want all columns to sort. I'm not following what you mean
by, "the second lowest item in the last column is on the same row as the
third lowest item in the next to last column"?

I'll try to explain this in a bit more detail, There were 74 surveys (Column
E) sent to staff with 10 questions (Column A)u. The surveys were sent to 3
sections or departments (Columns B, C and D)). Under each Section heading
(again Columns B, C, and D) are the results (%) of respondents answering each
question. The number of surveys returned (Column F) actually shows the
number of surveys answering each question in Column A. The % of surevys
returned that answered each question is in Column G. Column H is the average
percent of all 3 sections answering each question in Column A.

This was dumped in my lap orginally as a MSWord table and the person
responsible for this was having a hard time ranking the areas that need
attention as far as process improvements. What they need isQuestions ranked
in order by the last two columns. We can omit question 8 since there were no
answers provided, but the person I'm working with indicated that she felt the
number one priority is question 1 since 100% of those surveyed rersponded to
that question but it only generated a 55% in Column H.

I hope I've not mudded the water more than clearing it up,
Mike