array problem in Percentile function

[mingali]

Hi,

I have two set of ranges of cells to be put in array, do you guys able to help me with this one for Percentile Function?

Ie Percentile = (array, k)
array that need to be input is A1:A10 and A30:A40

Thanks

[DonkeyOte]

Would the below work for you ?

=PERCENTILE((A1:A10,A30:A40),k)

If the contents of A11:A29 are non-numeric you could just use the contiguous range of A1:A40