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