Originally Posted by LFCDRM

Hi, S.

Is it not possible to upload an example workbook from excel? I tried, but it says I cannot upload such a file...

Anyways I attached a picture of an example which hopefully helps illustrate the problem.

As you can see I have a table with information in several different columns. (And their ordering changes when I use the filter button.)

I want to create a formula that gives me the median of the top quartile in column P. I.e. the median of the 25% with the highest numbers in this column.

Manually I would have to work out the top 25% of the sample. And calculate the median of this sample. I.e. if there are 100 numbers, I would want the formula to fetch the 13th largest (25% of 100 is 25, and median of 25 is 13).

Do you have any insights as to how I might proceed? My thinking is that I ideally want to use the Quartile function to fetch the numbers somehow - so that the size of the sample can easily be changed without it affecting my calculations.

Best regards,
Lasse