ranking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
=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)
 
=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)
 
Hi Dave,
Yes I could but this table is being built from a seperate spreadsheet and
I would like it to automatically arrange them in order as the information is
entered into the other sheet.
 
Cheers Bob that worked a treat.

Bob Phillips said:
=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)
Click to expand...
 
Back
Top