E
Excelicious
When I do the rank function it does it backwards. Meaning the lowest value
has a higher rank. Can this be turned around?
has a higher rank. Can this be turned around?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
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.
=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.
E
Excelicious
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.
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.
A
Alan
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.
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.
T
T. Valko
Make sure you have calculation set to automatic.
Tools>Options>Calculation tab>Automatic>OK
Tools>Options>Calculation tab>Automatic>OK