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

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

I was hoping to pull a separate list, rather than running a data sort
(as easy as that is) and am relatively new to the Rank function. I
know I could do this with inserting a column and adding a vlookup, but
that will complicate other macros I have going on with this document.

With that, I am wondering if there is a formula that will do it.

Enter this in C1, and copy down

=INDEX($A$1:$A$10,MATCH(ROW(),RANK($B$1:$B$10,$B$1 :$B$10),0))

it is an array formula, so commit with Carol-Shift-Enter. Change the 10 to a
realistic number for you

--
HTH

Bob Phillips

"gmunro" wrote in message
oups.com...
I was hoping to pull a separate list, rather than running a data sort
(as easy as that is) and am relatively new to the Rank function. I
know I could do this with inserting a column and adding a vlookup, but
that will complicate other macros I have going on with this document.

With that, I am wondering if there is a formula that will do it.

"Bob Phillips" wrote in message
...
it is an array formula, so commit with Carol-Shift-Enter. Change the 10 to
a

Hi Bob

Who's Carol? :-)

--
Ian
--

She's the damned spell-checker <vbg

--
HTH

Bob Phillips

"Ian" wrote in message
...
"Bob Phillips" wrote in message
...
it is an array formula, so commit with Carol-Shift-Enter. Change the 10
to
a

Hi Bob

Who's Carol? :-)

--
Ian
--