| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentile - data in 2 different ranges | Excel Discussion (Misc queries) | |||
| Reading data arrays from multiple data files in excel | Excel Discussion (Misc queries) | |||
| Use excel to calculate a percentile from data in multiple sheets | Excel Worksheet Functions | |||
| Maximum data points for PERCENTILE function? | Excel Programming | |||
| Returning all data from a list above the nth percentile | Excel Worksheet Functions | |||
Threaded Mode
