Help with Percentile function

[calof1]

Hi,

I have the attached spreadsheet which contains a large volume of data. I have found the percentile function works for my top cells (first 20,000). I am aware the formula seems to stop if the row count is beyond that. However even if i change to keep the row count the same, the formula seems to stop working. Does anyone have any ideas for the reason for this?

Many thanks,

[#2 · Accepted solution]

@calof1 

That's since you have #REF! here

If remove all works

[#3]

hi Sergei,

Thank you kindly for your assistance, very much appreciated.

Kind regards,