Essentially I need a =SUMIF type method for a different function, in this case the PERCENTILE function.
<tbody>
</tbody>
If I wanted to SUM the yellow numbers (which I don't want to do, but in similar),
I'd use the function =SUMIF(b1:b6,"yellow",a1:a6).
In my case, I want to compute the PERCENTILE for each of the unique values in column B. So I want to create a formula for each of the unique values I have in the table: this would be the name of my imaginary function: =PERCENTILEIF(b1:b6,40%,"yellow",a1:a6).
This would return the value of the 40% percentile of the array (though obviously not enough data to compute that percentile).
If there was a function that returned an array derived based on matching values of another column in the same array, that would be ideal. I would then put that array in the =PERCENTILE function.
a | b | |
1 | 5 | yellow |
2 | 7 | green |
3 | 11 | yellow |
4 | 15 | red |
5 | 19 | yellow |
6 | 21 | green |
<tbody>
</tbody>
If I wanted to SUM the yellow numbers (which I don't want to do, but in similar),
I'd use the function =SUMIF(b1:b6,"yellow",a1:a6).
In my case, I want to compute the PERCENTILE for each of the unique values in column B. So I want to create a formula for each of the unique values I have in the table: this would be the name of my imaginary function: =PERCENTILEIF(b1:b6,40%,"yellow",a1:a6).
This would return the value of the 40% percentile of the array (though obviously not enough data to compute that percentile).
If there was a function that returned an array derived based on matching values of another column in the same array, that would be ideal. I would then put that array in the =PERCENTILE function.
Last edited: