Instance of match?

[Jaymond Flurrie]

I have this
A1 = Me
A2 = You
A3 = Her
B1 = 4
B2 = 4
B3 = 5

I want automatic order of those somewhere. So I have

E1 = LARGE(B1:B3,1)
E2 = LARGE(B1:B3,2)
E3 = LARGE(B1:B3,3)
D1 = INDEX($A$1:$B$1;MATCH(E1;$B$1:$B$3;0);1)
D2 = INDEX($A$1:$B$2;MATCH(E2;$B$1:$B$3;0);1)
D3 = INDEX($A$1:$B$3;MATCH(E3;$B$1:$B$3;0);1)

But that doesn't work because B1 = B2 => Match returns the same. How do I say take the 1st match or 2nd match without knowing how many there are in advance? Do I need to go by countif and if so, then what?

 

[Aladin Akyurek]

In E1 just enter and copy down:

=IF(ROWS($E$1:E1)>COUNT($B$1:$B$3),"",LARGE($B$1:$B$3,ROWS($E$1:E1)))

In D1 control+shift+enter, not just enter, and copy down:

=IF($E1="","",INDEX($A$1:$A$3,SMALL(IF($B$1:$B$3=$E1,ROW($A$1:$A$3)-ROW($A$1)+1),COUNTIFS($E$1:E1,E1))))