Nov 24 2021 09:23 PM
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,
Nov 24 2021 10:58 PM - edited Nov 24 2021 10:58 PM
Just in case someone else wants to have a go at it, he/she doesn't have to re-invent the wheel.