Formula to Rank a table of Data

[dandavis1]

Please See Attached

I have added a formula (Column C) to rank the following Data. There is probably an easy solution here. It is currently showing 1 at the bottom and 13 at the top. I want it to be the other way round. ANy suggestions?

Thanks for your help!!

[canapone]

Hi,

in C4 and beneath

=COUNTIF($D$4:$D$16,">"&D4)+COUNTIF($D$4:D4,$D4)

Regards

[dandavis1]

Thanks for your help. However i was hoping to keep the same formula i had, because it takes into account that if the sums are equal then the ranking will show that, for example if the top two both had 90% then they would both have a rank of 1. This formula does not do this and just lists from 1-43. I was just hoping to amend my formula slightly so rank 1 is at the top instead of at the bottom.

[DonkeyOte]

Simply change the optional Order variable in RANK from 1 to 0 - see XL Help for more info. on RANK

[dandavis1]

thats sorted, many thanks for your help