excel formula special method for ranking of numbers

[ramo]

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:

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>

 

[vogel997]

Does this work for you?

101	2	=RANK(A1,$A$1:$A$11,1)	101	10	=RANK(D1,$D$1:$D$11,0)
120	3	=RANK(A1,$A$1:$A$11,1)	120	8	=RANK(D1,$D$1:$D$11,0)
100	1	=RANK(A1,$A$1:$A$11,1)	100	11	=RANK(D1,$D$1:$D$11,0)
120	3	=RANK(A1,$A$1:$A$11,1)	120	8	=RANK(D1,$D$1:$D$11,0)
160	9	=RANK(A1,$A$1:$A$11,1)	160	2	=RANK(D1,$D$1:$D$11,0)
160	9	=RANK(A1,$A$1:$A$11,1)	160	2	=RANK(D1,$D$1:$D$11,0)
150	7	=RANK(A1,$A$1:$A$11,1)	150	4	=RANK(D1,$D$1:$D$11,0)
150	7	=RANK(A1,$A$1:$A$11,1)	150	4	=RANK(D1,$D$1:$D$11,0)
135	6	=RANK(A1,$A$1:$A$11,1)	135	6	=RANK(D1,$D$1:$D$11,0)
129	5	=RANK(A1,$A$1:$A$11,1)	129	7	=RANK(D1,$D$1:$D$11,0)
678	11	=RANK(A1,$A$1:$A$11,1)	678	1	=RANK(D1,$D$1:$D$11,0)

<colgroup><col span="2"><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[ramo]

Hi Vogel,
Thanks for the reply.
I need the ranking to be as indicated.
Your method skips one ranked when two numbers are equal.

 

[FormR]

Maybe like this:

Excel Workbook
	A	B	C	D	E	F
1	101	2			101	10
2	120	4			120	9
3	100	1			100	11
4	120	4			120	9
5	160	10			160	3
6	160	10			160	3
7	150	8			150	5
8	150	8			150	5
9	135	6			135	6
10	129	5			129	7
11	678	11			678	1
Sheet1

 

[ramo]

Great stuff FormR,
Tested the formula and it works like a Bomb!!@
Thanx a Lot