ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximum data points for PERCENTILE function? (https://www.excelbanter.com/excel-programming/360101-maximum-data-points-percentile-function.html)

Don Wiss

Maximum data points for PERCENTILE function?
 
In the help for the PERCENTILE function it has "If array is empty or
contains more than 8,191 data points, PERCENTILE returns the #NUM! error
value." But it appears to work for much longer columns. Is the help wrong?
Or am I missing something?

I'm using xl2002.

Don <www.donwiss.com (e-mail link at home page bottom).


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com