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?
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
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