Thanks for the input!

I am not sure if the percentile calculations (despite the calculation makng intuitive sense gave me the correct numbers....I.e. the 12,5% percentile with a dataset from 1-28, does not return the nr.4 (median of 7, as 7*4=28), but rather 4,375)....


In the meantime I have decided to use a simplification to solve the issue. The formula I am using is:

=MEDIAN(INDEX('Raw data by country'!$O$6:$O$42;1;1):INDEX('Raw data by country'!$O$6:$O$42;ROUND(COUNT('Raw data by country'!$O$6:$O$42)/4;0);1))

The MatchIndex function works as I round the sample into equally sizeable chunks. Not mathematically perfect (due to the rounding issue), but at least it provides me with a good proxy :)



(And I can't use the filter function, but I guess I'll have to live with it for now :p )


Thx!