INDEX problem with cells of same value

[Guest]

Hi,

I have a list with names in A:1 to A:10, with associated values in B:1 to
B:10.

I want these to appear in list ranked by the values in cols C and D.

I have in C1 - =INDEX($A$1:$A$10,MATCH(D1,$B$1:$B$10,0))
and in D1 - =LARGE($B$1:$B$10,ROWS($1:1))

This works fine until I have two cells with the same value in col B.
Then I just get the same results repeated (essential the first name that
appears with that value).

Is it possible to have the following produced automatically?

A B C D
John 3 George 4
Paul 2 John 3
George 4 Paul 2
Ringo 2 Ringo 2

At the moment I would end up with two Pauls and no Ringo!

Thanks!

 

[RagDyeR]

This old post will show how to accommodate duplicates.


http://tinyurl.com/2tl9ar

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi,

I have a list with names in A:1 to A:10, with associated values in B:1 to
B:10.

I want these to appear in list ranked by the values in cols C and D.

I have in C1 - =INDEX($A$1:$A$10,MATCH(D1,$B$1:$B$10,0))
and in D1 - =LARGE($B$1:$B$10,ROWS($1:1))

This works fine until I have two cells with the same value in col B.
Then I just get the same results repeated (essential the first name that
appears with that value).

Is it possible to have the following produced automatically?

A B C D
John 3 George 4
Paul 2 John 3
George 4 Paul 2
Ringo 2 Ringo 2

At the moment I would end up with two Pauls and no Ringo!

Thanks!

 

[Guest]

Select your data range > sort your data Ascending order in column B

=INDEX($A$1:$A$10,MATCH(D1,$B$1:$B$10,1))