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

Question

Hi,&nbsp;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?&nbsp;Kind regards,&nbsp;&nbsp;

riny_van_eekelen · Answer

calof1&nbsp;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#M123524&nbsp;

Forum Discussion

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

1 Reply

Resources