Thanks, I seem to have tried everything but the easy way...

Now a bit more difficult: what if my range is in a different sheet in the
same book? The ranges are located in a different place in each sheet, so 3D
references won't work?

Your formula now becomes
=+PERCENTILE((A1:A4,Sheet2!D8:D11),0.9)

But stops working

Thanks a lot

"Domenic" wrote:

In article ,
Idoia wrote:

I need to calculate a percentile, but my data is not organized as one single
array, but in 2 ranges.

I've tried things like:
=+PERCENTILE({A1:A4,D8:D11},0.9)
=+PERCENTILE({A1:A4;D8:D11},0.9)
=+PERCENTILE(A1:A4&D8:D11,0.9)
={+PERCENTILE(A1:A4&D8:D11,0.9)}

Nothing seems to work... Any ideas?

Thanks

Try...

=PERCENTILE((A1:A4,D8:D11),0.9)

--
Domenic
http://www.xl-central.com