I would like to calculate the 95th percentile on a discontiguous cell range and exclude zeros from the calulation.
I am looking at using a single-cell array formula to accomplish this
I do not want to have to manipulate the source dat if possible - that is I want a formula that can work with a discontiguous cell range
I have experimented with contiguous ranges like this and it works
=PERCENTILE(IF(A1:A10<>0, A1:A10, ""), 0.95)
but when I try various attempts at a discontiguous range - no go!
Please help!
Also, what is a programming language for a newbie to get into working with Excel - would it be VBA? Where to get it and how to get started.
Thanks.
Any feedback would be greatly appreciated.
John
Bookmarks