Excell rank= I need to reverse the order

D

Dennis Noble

Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse
the order to high # equal 1st not last
 
B

barry houdini

Hello Dennis,

As Excel help explains, the 3rd argument of RANK function determines
the order. If it's zero or omitted then the ranking is in descending
order. If it's any number other than zero then ranking is in ascending
order, so to rank descending just remove the 3rd argument, i.e.

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

copied down
 
S

Shane Devenshire

Hi,

You should simplify the formula to read:

=RANK(A1,A$1:A$9) for descending
=RANK(A1,A$1:A$9,1) for ascending

using A1:A9 for the first argument instead of A1 gains nothing and is
overkill.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Rank order with conditions 3
Weighted ranking of a series 3
How to Rank Name? 4
Reverse ranking 1
Using rank to rate the winners in a competition 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Insert new photo album - photos are in reverse order 0

Top