In article ,
Idoia wrote:

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

If each range references a single column and the ranges are the same
size, try...

=PERCENTILE(CHOOSE({1,2},A1:A4,Sheet2!D8:D11),0.9)

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