Hello Jay,

LARGE does not help you if some values are appearing twice or more
often.

Put into C1:
=COUNTIF($B$1:$B$999,""&B1)+COUNTIF($B$1:B1,B1)
Into D1:
=INDEX(A:A,MATCH(ROW(),$C$1:$C$999,))
And into E1:
=INDEX(B:B,MATCH(ROW(),$C$1:$C$999,))
and copy down as far as necessary.

Hope that helps,
Bernd