Situation: I have data in multiple pages and I want to get the 95th percentile of a large array, combining data from each of the pages
The formula for Percentile requires the syntax as follows: PERCENTILE(ARRAY,k) where ARRAY is a continuous list, and K is a value between 0 and 1.
Here is the formula I tried:
In the formula above, the italicized array contains multiple arrays within the list.
The problem: Excel cannot read past the first comma, thus, Excel is interpreting the multi-component array as:
PERCENTILE('sheet1'!AG4:AG119,(not k) blah blah blah blah….) and obviously returning an error.
This didn't work:
Can anyone provide some light as to how to enter multiple arrays as a single array (where a comma separates the operators)?
Bookmarks