Can't you just use Data--Sort to do this?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Bob Phillips" wrote:

=SMALL($A$2:$A$13,ROW(A1))

will list the percentages in order.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Blade370" wrote in message
...
Cheers Bob,
But will this also automatically sort them into descending order?

"Bob Phillips" wrote:

=RANK(A2,$A$2:$A$13)

works for me.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Blade370" wrote in message
...
I have a table which looks like this

PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE
70.0% 5 3 1 1 10
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
66.7% 3 2 1 0 6
75.0% 2 1 0 1 4
50.0% 2 1 1 0 3
12.5% 4 0 3 1 1
50.0% 1 0 0 1 1
25.0% 2 0 1 1 1

I want to rank by the percentage column but when it still seems to rank
by
games won. Any ideas???