Rank

  • Thread starter Thread starter Jez
  • Start date Start date
J

Jez

How can I use the Rank function in reverse? i.e. if I
have a list of figures, the lowest being the best should
be ranked 1.
 
Hi
try the following (if A1:A100 stores your values)
=RANK(A1,$A$1:$A$100,1)

this uses the third parameter of the RANK function
 
You must log in or register to reply here.

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

Rank Formula 1
Using rank to rate the winners in a competition 2
Rank in ascending order in Excel 2003 5
min if horizontal 0
Rank - Change the Rank of a Tie 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
sort rank 3
Ranking Q 1

Back
Top