Function used to rank high to low?

[CAW]

I have a column of numbers (spanning just 15 rows) that are obtained using the formula =LARGE($C$9:$C$23,F9). What function do I use to show the rankings of these numbers (highest to lowest) in the column next to it? I don't want to sort the column, just show highest to lowest.

The numbers in the column obtained from the =LARGE($C$9:$C$23,F9) formula will change monthly based on data entered into another column, so whatever function is used will need to maintain its ability to rank highest to lowest.

Any help would be appreciated.

Thank you.

 

[jimrward]

check out the RANK function

 

[CAW]

Well that was easy.

Thanks!