ranking
 

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

ranking
 

=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???

ranking
 

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

ranking
 

=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???

ranking
 

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

ranking
 

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.

"Dave F" wrote:

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

ranking
 

Cheers Bob that worked a treat.

"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???