Excell rank= I need to reverse the order

  • Thread starter Thread starter Dennis Noble
  • Start date Start date
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
 
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

Reverse ranking 1
How to Rank Name? 4
Rank order with conditions 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Adjusting prizes to cater for ties 2
Using rank to rate the winners in a competition 2
Rank Formula 1
Ranking Function 4

Back
Top