I'd be very grateful for advice on the correct formula for establishing the upper quartile of an array of values next to a count of those values. In the attached example, the values (rents) are in column A and the count of those values (properties) are in column B. Is it possible to calculate the upper quartile of rents based on the number of properties using an array formula? It's driving me mad that I can't figure this out using the QUARTILE function - looks simple, but I can't find the right array formula to produce the desired output.

Thank you!

quartile array problem.xlsx