software

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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Curtisquot; gt; wrote in message
...
gt;I am trying to use the RANK function but I keep getting the largest number
gt; ranked the highest. I need to rank it the lowest
gt;
gt; Anyone???
gt;
gt; Thanks
gt;
gt; ce
Thanks, but that ranks the lowest number as 1. What I need is to rank the
highest number as 1.

quot;Peo Sjoblomquot; wrote:

gt; Use
gt;
gt; =RANK(A1,$A$1:$A$10,1)
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Curtisquot; gt; wrote in message
gt; ...
gt; gt;I am trying to use the RANK function but I keep getting the largest number
gt; gt; ranked the highest. I need to rank it the lowest
gt; gt;
gt; gt; Anyone???
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; ce
gt;
gt;
gt;

quot;Curtisquot; gt; wrote in message
...
gt; quot;Peo Sjoblomquot; wrote:

gt;gt; quot;Curtisquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to use the RANK function but I keep getting the largest
gt;gt; gt;number
gt;gt; gt; ranked the highest. I need to rank it the lowest

gt;gt; Use
gt;gt;
gt;gt; =RANK(A1,$A$1:$A$10,1)

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

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

Hint: Excel has a help facility.
--
David Biddulph
But ranking as number one is the highest, or are you saying that quot;it is
ranked number 1quot; 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

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

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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Curtisquot; gt; wrote in message
...
gt; Thanks, but that ranks the lowest number as 1. What I need is to rank the
gt; highest number as 1.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Use
gt;gt;
gt;gt; =RANK(A1,$A$1:$A$10,1)
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Excel 95 - Excel 2007
gt;gt; Northwest Excel Solutions
gt;gt; www.nwexcelsolutions.com
gt;gt; quot;It is a good thing to follow the first law of holes;
gt;gt; if you are in one stop digging.quot; Lord Healey
gt;gt;
gt;gt;
gt;gt; quot;Curtisquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to use the RANK function but I keep getting the largest
gt;gt; gt;number
gt;gt; gt; ranked the highest. I need to rank it the lowest
gt;gt; gt;
gt;gt; gt; Anyone???
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt; ce
gt;gt;
gt;gt;
gt;gt;
Thanks

quot;Peo Sjoblomquot; wrote:

gt; But ranking as number one is the highest, or are you saying that quot;it is
gt; ranked number 1quot; is not equal to the highest ranking? Regardless, if you
gt; want to rank the other way just use zero or omit the last number. I guess I
gt; misunderstood when you said
gt;
gt; quot;I am trying to use the RANK function but I keep getting the largest number
gt; ranked the highest. I need to rank it the lowestquot;
gt;
gt; and with
gt;
gt; 1
gt; 5
gt; 10
gt;
gt; my formula returns
gt;
gt; 1
gt; 2
gt; 3
gt;
gt; So to me it sounds as if you mean the opposite to what you said
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Excel 95 - Excel 2007
gt; Northwest Excel Solutions
gt; www.nwexcelsolutions.com
gt; quot;It is a good thing to follow the first law of holes;
gt; if you are in one stop digging.quot; Lord Healey
gt;
gt;
gt; quot;Curtisquot; gt; wrote in message
gt; ...
gt; gt; Thanks, but that ranks the lowest number as 1. What I need is to rank the
gt; gt; highest number as 1.
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; Use
gt; gt;gt;
gt; gt;gt; =RANK(A1,$A$1:$A$10,1)
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Excel 95 - Excel 2007
gt; gt;gt; Northwest Excel Solutions
gt; gt;gt; www.nwexcelsolutions.com
gt; gt;gt; quot;It is a good thing to follow the first law of holes;
gt; gt;gt; if you are in one stop digging.quot; Lord Healey
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Curtisquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am trying to use the RANK function but I keep getting the largest
gt; gt;gt; gt;number
gt; gt;gt; gt; ranked the highest. I need to rank it the lowest
gt; gt;gt; gt;
gt; gt;gt; gt; Anyone???
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks
gt; gt;gt; gt;
gt; gt;gt; gt; ce
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;