Using the Percentile function on assorted cell instead of a continuous range

JOHN ERTEL

How do I use the "Percentile" function on assorted cell instead of a continuous range. It works fine for B1:B30, but gives me an error when I put B1, B2, B4, B5, B14, B27. Any suggestions on how to make this work?

Paul Newcome

What is the reason for needing to skip specific rows?

You could try adding a "helper" checkbox column and checking the rows you want to use.

Then you could use something along the lines of...

=PERCENTILE(COLLECT(B1:B30, Helper1:Helper30, 1), n)