Ranking
 

I am trying to use the RANK function but I keep getting the largest number
ranked the highest. I need to rank it the lowest

Anyone???

Thanks

ce

Ranking
 

Use

=RANK(A1,$A$1:$A$10,1)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
I am trying to use the RANK function but I keep getting the largest number
ranked the highest. I need to rank it the lowest

Anyone???

Thanks

ce

Ranking
 

Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.

"Peo Sjoblom" wrote:

Use

=RANK(A1,$A$1:$A$10,1)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
I am trying to use the RANK function but I keep getting the largest number
ranked the highest. I need to rank it the lowest

Anyone???

Thanks

ce

Ranking
 

"Curtis" wrote in message
...
"Peo Sjoblom" wrote:

"Curtis" wrote in message
...
I am trying to use the RANK function but I keep getting the largest
number
ranked the highest. I need to rank it the lowest

Use

=RANK(A1,$A$1:$A$10,1)

Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.

In which case, that is the default behaviour for RANK(). Leave out the ",1"
at the end & just use =RANK(A1,$A$1:$A$10)

Hint: Excel has a help facility.
--
David Biddulph

Ranking
 

But ranking as number one is the highest, or are you saying that "it is
ranked number 1" is not equal to the highest ranking? Regardless, if you
want to rank the other way just use zero or omit the last number. I guess I
misunderstood when you said

"I am trying to use the RANK function but I keep getting the largest number
ranked the highest. I need to rank it the lowest"

and with

1
5
10

my formula returns

1
2
3

So to me it sounds as if you mean the opposite to what you said


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.

"Peo Sjoblom" wrote:

Use

=RANK(A1,$A$1:$A$10,1)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
I am trying to use the RANK function but I keep getting the largest
number
ranked the highest. I need to rank it the lowest

Anyone???

Thanks

ce

Ranking
 

Thanks

"Peo Sjoblom" wrote:

But ranking as number one is the highest, or are you saying that "it is
ranked number 1" is not equal to the highest ranking? Regardless, if you
want to rank the other way just use zero or omit the last number. I guess I
misunderstood when you said

"I am trying to use the RANK function but I keep getting the largest number
ranked the highest. I need to rank it the lowest"

and with

1
5
10

my formula returns

1
2
3

So to me it sounds as if you mean the opposite to what you said


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.

"Peo Sjoblom" wrote:

Use

=RANK(A1,$A$1:$A$10,1)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curtis" wrote in message
...
I am trying to use the RANK function but I keep getting the largest
number
ranked the highest. I need to rank it the lowest

Anyone???

Thanks

ce