View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
 
Posts: 41
Default Percentile -- how to?

Hi

I have 5mio currency values in an unsorted VBA array. I need to find the
99.99th percentile highest value without writing the array to a spreadsheet
and using the worksheetfuntion.percentile

Any ideas? TIA!!

Rgds,
BR

--
Capital Markets
GE Capital, London