Dear Friends,
I need a solution, to the problem below.
I have a list of numbers that I need to rank from highest to lowest then from lowest to highest.
The duplicate numbers must have the same rank as indicated in the example below.
I thank you in advance
Example:
<COLGROUP><COL style="WIDTH: 54pt" span=6 width=72><TBODY>
</TBODY>
I need a solution, to the problem below.
I have a list of numbers that I need to rank from highest to lowest then from lowest to highest.
The duplicate numbers must have the same rank as indicated in the example below.
I thank you in advance
Example:
List | Rank High - Low | List | Rank Low - High | ||
101 | 2 | 101 | 10 | ||
120 | 4 | 120 | 9 | ||
100 | 1 | 100 | 11 | ||
120 | 4 | 120 | 9 | ||
160 | 10 | 160 | 3 | ||
160 | 10 | 160 | 3 | ||
150 | 8 | 150 | 5 | ||
150 | 8 | 150 | 5 | ||
135 | 6 | 135 | 6 | ||
129 | 5 | 129 | 7 | ||
678 | 11 | 678 | 1 |
<COLGROUP><COL style="WIDTH: 54pt" span=6 width=72><TBODY>
</TBODY>