PERCENTILE exceeding 8191 points

M

mtrain32000

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.
 
B

Bernard Liengme

It worked for me also. It would seem that Help and the MS Knowledge Base
page are wrong in this matter
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top