Thread: Rank and Sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default 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