Does the percentile function on stop working if data set is to large?

Regular Contributor

Hi,

 

I have a large data set, 86,000 results. I am hoping to use percentile to find certain levels of results. The results work fine with the formula when there is less results, however doesn't seem to calculate with the full data set. Is there a limit to the number of results it will work for?

 

Kind regards,

 

 

1 Reply

@calof1 

Just in case someone else wants to have a go at it, he/she doesn't have to re-invent the wheel.

https://techcommunity.microsoft.com/t5/excel/help-using-nested-if-formula-in-percentile/m-p/2999821#...