ExcelBanter - Percentile - Data in arrays

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Percentile - Data in arrays (https://www.excelbanter.com/excel-programming/365202-percentile-data-arrays.html)

Bharath Rajamani

Percentile - Data in arrays

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

--

All times are GMT +1. The time now is 01:18 AM.