View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default 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).