Rank a column by a given average

[JustinRSanchez]

Hello all!

So I am trying to rank a column of numerical data by a given average of the cells:

Assume,

Column "D" is:
<table width="86" border="0" cellpadding="0" cellspacing="0"><col style="width: 65pt;" width="86"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 65pt;" width="86" height="17"> $60,493.53 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $74,779.67 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $60,685.49 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $61,814.74 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $83,021.44 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $101,901.65 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $116,018.84 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $40,817.55 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $64,541.84 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $67,784.67 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $92,937.34 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $65,810.22 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $49,417.83 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $43,350.75 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $14,186.34 </td><td valign="top">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" height="17"> $997,561.90(Total)

Column "D" has an average of ($66,504.13)

How would I make column "C' reflect a ranking system (1-15), based on the average of ($66,504.13)?

</td><td valign="top">
</td> </tr> </tbody></table>

 

[shg]

How does the average affect the ranking?

 

[JustinRSanchez]

I am trying to have column "C" rank each cell in column "D" by the average given.

So, the average of data in column "D" is ($66,504.13).

So column "C" would display a rank for the data in column "D".

At the moment I have only given 15 rows of information however, the formula I trying to figure out would be applicable to 2500+ rows of information.

 

[shg]

That doesn't explain how the average affects the ranking. What should the results be for the example you posted?

 

[JustinRSanchez]

Apologies, I understand now.

Column C would reflect a numerical rank based on the average (66504.12)

So, the higher the value of the cell the higher the rank... making the average irrelevant...

Hm.. Do you know if this formula would rank my information?

=RANK(C2,$C$2:$C$115)

With C115 being the last row...?
<table width="150" border="0" cellpadding="0" cellspacing="0" height="292"><tbody><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt; width: 65pt;" width="86" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl22" style="height: 12.75pt;" align="left" height="17">
</td><td valign="top">
</td></tr><tr style="height: 12.75pt;" align="left" height="17"><td class="xl22" style="height: 12.75pt;" height="17">
</td></tr></tbody></table>

 

[shg]

Indeed it would.