I'd like the price returned for the minimum price in the 2nd quartile, the median price, and the maximum price in the 3rd quartile.
What formulas can I use to achieve this?
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
What formulas can I use to achieve this?
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Product Price | Model No. | Sum of Quantity |
2.1 | qpRSS0015SS0 | 200 |
qpRSS0015SS15 | 200 | |
qpRSS0015SS7 | 200 | |
qpRSS0015SS8 | 200 | |
2.6 | qpRSM0015SS0 | 200 |
qpRSM0015SS15 | 200 | |
qpRSM0015SS8 | 200 | |
qpRSM0015SS7 | 200 | |
3.04 | qpF815000040 | 500 |
3.09 | qpF85717040 | 337 |
4.45 | FMDqpPS014A | 1,941 |
FMDqpPS014B | 1,941 | |
FMDqpPS014C | 1,941 | |
FMDqpPS015A | 1,941 | |
FMDqpPS015B | 1,986 | |
FMDqpPS015C | 1,901 | |
Grand Total | 14,088 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>