Excel ranking in descending Order

[Garrett]

How do you rank values in a table in descending order? For instance the lower the number the higher the ranking.

 

[Aladin Akyurek]

On 2002-08-29 15:11, Garrett wrote:
How do you rank values in a table in descending order? For instance the lower the number the higher the ranking.

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

would rank the lowest value as highest in rank.

 

[Jack in the UK]

Hi

Try this:
=RANK(A1,A2:Axx,1)
The 1 will made assending if you need decending make the 1 a 0 for decending

Also change the the xx needs aligning to your range

HTH

 

[Garrett]

Thanks for your help! Your solution helped me out but posed me w/another problem.

In my excel spreadsheet, I have 4 ranking columns. 2 need to rank in ascending order and 2 need to rank in descending order.

When I added the ,1 to my formula and dragged it down to all 34 cells, it gave me a gap between the #1 rank and the #2 rank. Instead it jumped from #1 to #34. Can you help w/this?

 

[Aladin Akyurek]

On 2002-08-30 09:53, Garrett wrote:
Thanks for your help! Your solution helped me out but posed me w/another problem.

In my excel spreadsheet, I have 4 ranking columns. 2 need to rank in ascending order and 2 need to rank in descending order.

When I added the ,1 to my formula and dragged it down to all 34 cells, it gave me a gap between the #1 rank and the #2 rank. Instead it jumped from #1 to #34. Can you help w/this?

I don't understand that jumping...

Could you post your current formula?

 

[Garrett]

Sure, my formula is: =RANK(F3,$F$3:$F$36,1)

I'm using it to rank individuals w/absences. If you have 0 absences then you should rank 1. If you have 1 absence, then you should rank 2, 2 absences should rank you at 3, etc.

 

[Garrett]

Hi There,

I figured out what I was doing wrong. I needed to adjust range. I orginally had a range that had data with "0" in it. Once I change the range to the cells with info in it, the correct ranking appeared. Thanks for your time and help! You guys still Rock!