Forum Discussion

calof1's avatar
calof1
Iron Contributor
Mar 03, 2022
Solved

Help with Percentile function

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,

Resources