Small Function Match

[rehberger]

I was using the small function until I got stuck. Is there a way I can match the name to a value when there are duplicates?
For example, in the chart below, I would like to order these from smallest to largest and then bring in the name next to it also. Since I have two names with $1 how do I write a formula that will bring in both names?

Name	Amount
David	$1
Mark	$5
Jim	$7
Tom	$1
Ric	$4

<tbody>
</tbody>

 

[Weazel]

maybe something like....

Unknown

	A	B	C	D	E	F
1	Name	Amount
2	David	$1		1	1	David
3	Mark	$5		2	1	Tom
4	Jim	$7		3	4	Ric
5	Tom	$1		4	5	Mark
6	Ric	$4		5	7	Jim

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E2 =SMALL($B$2:$B$6,D2) <tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula F2 {=INDEX($A$2:$A$6,SMALL(IF($B$2:$B$6=E2,ROW($B$2:$B$6)-ROW($B$2)+1),COUNTIF($E$2:E2,E2)))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[rehberger]

maybe something like....

Unknown

	A	B	C	D	E	F
1	Name	Amount
2	David	$1		1	1	David
3	Mark	$5		2	1	Tom
4	Jim	$7		3	4	Ric
5	Tom	$1		4	5	Mark
6	Ric	$4		5	7	Jim

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E2 =SMALL($B$2:$B$6,D2) <tbody> </tbody>

<tbody>
</tbody>

Array Formulas Cell Formula F2 {=INDEX($A$2:$A$6,SMALL(IF($B$2:$B$6=E2,ROW($B$2:$B$6)-ROW($B$2)+1),COUNTIF($E$2:E2,E2)))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

Thank You, that worked