Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percetile function limitation
Hi,
This is taken from Help file "If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value. " My array is way over 8,191 data points, is there a workaround? Maybe VBA code? Thank you, -- ______ Regards, Greg |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percetile function limitation
Greg -
One way is to sort the range (or make a copy and then sort the copy), use an adjacent column for cumulative relative frequency (perhaps using Excel's nonstandard approach from 0 to 1 in steps of 1/(n-1)), and get the percentile using a lookup function. - Mike www.mikemiddleton.com "Greg" wrote in message ... Hi, This is taken from Help file "If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value. " My array is way over 8,191 data points, is there a workaround? Maybe VBA code? Thank you, -- ______ Regards, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The 7 nested If() function Limitation. Is there anouther way? | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Function limitation | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |