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 |
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) |