I have this list of numbers and want the precentile score for them.
Ex:
1
3
6
8 < - i want to exclude this number from the percentile.
9
4
7
8
9
Right now i have =PERCENTILE.INC(F13:F61,0.25) which works but includes the number i want to exclude. When i try something like =PERCENTILE.INC(F13:F15,F17:F18,0.25), it returns an error.
How do i tell it to select all numbers except some?
PERCENTILE.INC() accepts a range references list as argument for its first parameter, so use the ~ union operator
=PERCENTILE.INC((F13:F15~F17:F21);0.25)Note that it’s best to place parentheses around that subexpression (F13:F15~F17:F21) in case things are to be exported to .xlsx format (where it becomes (F13:F15,F17:F21) hence needs them to distinguish from parameter separator), Calc and ODF don’t need them. It might as well be that Excel doesn’t support a range list at all in this context, didn’t try.
works! tyy