PERCENTILE exceeding 8191 points

  • Thread starter Thread starter mtrain32000
  • Start date Start date
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.
 
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

Similar Threads

A Percentile IF function 1
Percentile on Aggregate data with multiple criteria 0
Calculate Percentiles with dynamic ranges 5
percetile function limitation 1
Calculating percentile on array with >65536 elements 6
Percentiles 1
Awkward Query Idea / Help!? Percentiles. 2
Help: Election 2004 Project -- Iterative Operations 1

Back
Top