Ranking

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

Guest

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
 
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
 
Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.
 
Curtis said:
"Peo Sjoblom" wrote:
Click to expand...
Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.
Click to expand...

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.
 
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
 
Thanks

Peo Sjoblom said:
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
Click to expand...
 
Back
Top