The 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D and E
In B3 down is: 35, 45, 13, 8 and 3.

The result which I want is to list the data E, D, C, A and B from the cell C3
to C7. I want a formula which know how to rank the data in which the Excel
formula know B has the highest value of 45 and E has the lowest value of 3.

Many thanks,

Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1