Using PERCENTILE with *specific* cells in a column

[zodiac711]

I am trying to use the PERCENTILE function with specific cells in a column.

For example, lets say the column is:
A
1 5
2 6
3 7
4 8


Using PERCENTILE on say A1:A3 is easy enough, but I want to do say A1 and A4.

I can achieve this by defining a named range such that it would be equal to
A1 and A4, but would rather not use named ranges, as the above is a very
simplistic example of what I want to do -- using named ranges would require a
substantial amount of effort to achieve my end goal.

I also realize I could re-order the rows such that I swap A4 with A2,
therefore could use percentile on A1:A2, but that will not work for my needs
either.


I attempted to use the INDIRECT function in an array constant, but realized
that you can't use a function in an array constant, so that rules that
thought out.

Is there a way I can "create" the range to be used in an Excel formula (ala
the RANGE function in VBA)? The named range is doing this (as it works), but
I can't figure out how to emulate it within my Excel workbook.

Thanks for any advice

 

[Bernard Liengme]

Try =PERCENTILE((A1,A4),0.95)
best wishes

 

[zodiac711]

Bernard,

Thank-you! I can't believe it was THAT simple... I consider myself to be
highly proficient with Excel, but could NOT figure that out...! Argh!


Thank-you again -- that worked exactly as I needed it to.

 

[Bernard Liengme]

You are very welcome. Thanks for the feedback