Use the third argument to sort ascending or descending
=RANK(A1,$A$1:$A$10,0)
sorts descending, (also if you leave the 0 out),
=RANK(A1,$A$1:$A$10,1)
sorts ascending,
Regards,
Alan.
The formula worked great, however again I cannot get the formula to copy down
as it keeps referencing orginal references.
=RANK(D3,$D$3:$J$3,1) <<<--- Works Great
=RANK(D4,$D$3:$J$3,1) <<<---- Next line still referencing D3 info.
=RANK(D5,$D$3:$J$3,1) <<<---- Next line still referencing D3 info.
=RANK(D6,$D$3:$J$3,1) <<<---- Next line still referencing D3 info.
You need to copy it across, not down, ie enter the formula in D3 and drag it
across to J4 so you aren't get D3, D4, D5 etc, but D3,E3, F3 etc.
You must have both the cell to rank and the range to rank it from in either
columns or rows, you can't mix them,
Regards,
Alan.
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.
