Can't you use Data|Sort|Descending on the Quantity?

--
Ian
--
"gmunro" wrote in message
oups.com...
Hello,

Based on the following example:

Item Quantity
A 2
S 7
D 3
F 6

I am looking for a ranking formula that will pull the data from the
first column based on the ranking of the second column
so that the end result will look like this
1 S
2 F
3 D
As S has the largest quantity, F 2nd largest etc

The list I will pull this from is variable in length but in the
hundreds.

Any help would be appreciated.

Glen