View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pinkfloydfan pinkfloydfan is offline
external usenet poster
 
Posts: 68
Default Calculating percentile on array with 65536 elements

Hi all

The Percentile worksheet function is great but unfortunately seems to
have a limit of 65536 elements; try and use it on an array with more
elements than that and it returns an error.

So, if you have a larger array does anyone have any better ideas for
calculating a specific percentile without sorting the array first?

Thanks a lot
Lloyd