View Single Post
  #5   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

That is very true but in actual fact the function works with upto
65536 elements (having tested it out)...just a small example of the
Help being inaccurate.

However, back to the original problem...does anybody have any ideas
how to calculate a specific percentile of a very large array without
having to sort the array first please?

Cheers
Lloyd