Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PERCENTILE exceeding 8191 points
The excel 2003 SP2 "help" for the percentile function says that percentile
does not support more than 8191 data points. It says that it will return #NUM! if the array is empty or contains more than 8191. I just calculated percentile with 10,294 data points [ =PERCENTILE(G1:G10294,0.95) ] , and I normally perform similar calculations every week. Why does this work for me when Microsoft says it shouldn't? I've also seen similar comments on the internet describing the same thing. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PERCENTILE exceeding 8191 points
It worked for me also. It would seem that Help and the MS Knowledge Base
page are wrong in this matter best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "mtrain32000" wrote in message ... The excel 2003 SP2 "help" for the percentile function says that percentile does not support more than 8191 data points. It says that it will return #NUM! if the array is empty or contains more than 8191. I just calculated percentile with 10,294 data points [ =PERCENTILE(G1:G10294,0.95) ] , and I normally perform similar calculations every week. Why does this work for me when Microsoft says it shouldn't? I've also seen similar comments on the internet describing the same thing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If Exceeding 7 Calculations | Excel Discussion (Misc queries) | |||
exceeding columns limit | Excel Discussion (Misc queries) | |||
calculate the sum of hours exceeding 23:56 | Excel Worksheet Functions | |||
Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
Exceeding 65,000 rows | Excel Discussion (Misc queries) |