Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank and Sort
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank and Sort
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "watermt" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank and Sort
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 "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "watermt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank then sort then pastelink | Excel Worksheet Functions | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
Microsoft Excel Rank and Sort | Excel Discussion (Misc queries) | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |