Using SMALL function to determine smallest of groups

[mark91345]

I know how to use the SMALL function to determine the nth smallest figure; however, when you have a table like this, how do I determine the 3rd smallest figure from the GROUP?

For example, if I could $25,000 as a single group, $30,000 as another group, and so forth. In this case, $35,000 would be the 3rd smallest figure within the group. How do I do that?

	A	B	C	D
Salary	Results	Salary result
$25,000	1st smallest
$25,000	2nd smallest
$25,000	3rd smallest
$30,000
$35,000
$35,000
$40,000

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: right"]$25,000[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: right"]$25,000[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: right"]$25,000[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet3​

 

[Marcelo Branco]

Maybe...

D2 copied down
=SMALL(A$2:A$8,1+SUMPRODUCT(COUNTIF($A$2:$A$8,D$1:D1)))

M.