ExcelBanter - Ranking

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Ranking (https://www.excelbanter.com/excel-worksheet-functions/157770-ranking.html)

I need some assistance ranking a set of numbers. Here is the help screen
that Microsoft provides.

A
Data
1 7
2 3.5
3 3.5
4 1
5 2

Formula Description (Result)
=RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3)
=RANK(A2,A2:A6,1) Rank of 7 in the list above (5)

This works great if I want to rank cell A1 #5. What is the formula is I
want cell A1 (the highest) to be ranked #1?

Thanks in advance for your help.

Regards,

Cory

Never mind, I think I just figured it out. For those that are wondering, it
appears to me that the formula should be:

=RANK(A2,A2:A6,0) Rank of 7 in the list above (1)

This appears to work. If this is not correct, please let me know.

Regards,

Cory

"dellbad" wrote:

I need some assistance ranking a set of numbers. Here is the help screen
that Microsoft provides.

A
Data
1 7
2 3.5
3 3.5
4 1
5 2

Formula Description (Result)
=RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3)
=RANK(A2,A2:A6,1) Rank of 7 in the list above (5)

This works great if I want to rank cell A1 #5. What is the formula is I
want cell A1 (the highest) to be ranked #1?

Thanks in advance for your help.

Regards,

Cory

Yes, that is correct, although you will probably want to make it:

=RANK(A2,A$2:A$6,0)

if you want to copy it down.

You could also look at the LARGE and SMALL functions.

Hope this helps.

Pete

On Sep 10, 11:20 pm, dellbad
wrote:
Never mind, I think I just figured it out. For those that are wondering, it
appears to me that the formula should be:

=RANK(A2,A2:A6,0) Rank of 7 in the list above (1)

This appears to work. If this is not correct, please let me know.

Regards,

Cory

"dellbad" wrote:
I need some assistance ranking a set of numbers. Here is the help screen
that Microsoft provides.

A
Data
1 7
2 3.5
3 3.5
4 1
5 2

Formula Description (Result)
=RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3)
=RANK(A2,A2:A6,1) Rank of 7 in the list above (5)

This works great if I want to rank cell A1 #5. What is the formula is I
want cell A1 (the highest) to be ranked #1?

Thanks in advance for your help.

Regards,

Cory- Hide quoted text -

- Show quoted text -