| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentile on array with 65536 elements
Hi all
The Percentile worksheet function is great but unfortunately seems to have a limit of 65536 elements; try and use it on an array with more elements than that and it returns an error. So, if you have a larger array does anyone have any better ideas for calculating a specific percentile without sorting the array first? Thanks a lot Lloyd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using percentile in an array formula | Excel Worksheet Functions | |||
| Use formulas for array elements | Excel Discussion (Misc queries) | |||
| to get its k-value from percentile and array | Excel Programming | |||
| to get its k-value from percentile and array | Excel Worksheet Functions | |||
| Use of Array Pivot Table for Percentile Calculation ... | Excel Worksheet Functions | |||
Threaded Mode
