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
1	Salary		Results	Salary result
2	$25,000		1st smallest	$25,000
3	$25,000		2nd smallest	$25,000
4	$25,000		3rd smallest	$25,000
5	$30,000
6	$35,000
7	$35,000
8	$40,000

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

 

[Marcelo Branco]

Maybe...

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

M.