Formula required for ascending values

[wheels1]

I would like to find a formula that produces Names and $values in ascending order. Example :-
Cell a1 =John Cell b1 = $70
a2 = Bill b2 = $100
a3 = Jane b3 = $25
a4 = Frank b4 = $10
a5 = Mary b5 = $60
a6 = George b6 = $30.
ANSWER to be
Frank $10......Lowest price
Jane $25
George $30
Mary $60
John $70
Bill $100.
Thank you & hope this information is satisfactory

 

[Robert Mika]

I would like to find a formula that produces Names and $values in ascending order. Example :-
Cell a1 =John Cell b1 = $70
a2 = Bill b2 = $100
a3 = Jane b3 = $25
a4 = Frank b4 = $10
a5 = Mary b5 = $60
a6 = George b6 = $30.
ANSWER to be
Frank $10......Lowest price
Jane $25
George $30
Mary $60
John $70
Bill $100.
Thank you & hope this information is satisfactory

Do you expect any duplicates in your range?
So let say Bill and John can have $100

 

[wheels1]

Do you expect any duplicates in your range?
So let say Bill and John can have $100

No Robert it is most unlikely.

 

[wheels1]

Do you expect any duplicates in your range?
So let say Bill and John can have $100

No Robert it is most unlikely

 

[Robert Mika]

No Robert it is most unlikely

If you have no duplicates values

D2 copy down
=SMALL($B$1:$B$6,ROWS($A$1:A1))
E2:
=INDEX($A$1:$A$6,MATCH(D1,$B$1:$B$6,0))
If you have duplicated values replace the second doemula with this one
=INDEX($A$1:$A$6,SMALL(IF($B$1:$B$6=$D1,ROW($B$1:$B$6)-ROW($A$1)+1),ROWS($A$1:A1)-COUNTIF($D$1:D1,"<>"&D1)))
(this is array formula confrim Control+Shift+Enter

 

[wheels1]

Thank you Robert I will try those. Much appreciated.

 

[Robert Mika]

Thank you Robert I will try those. Much appreciated.

You are welcome.