Percentile - Data in arrays

B

BHARATH RAJAMANI

Hi .. I have an array of 1mio values (each value is a "loss-number" currency
value) .. I need to find the 99.99th percentile of these values ..

I do not want to dump the array into a sheet and run the percentile function
since its too slow.


TIA

BR

--
 

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

Top