Since discovering the power of array formulae I am finding many time saving applications. I am however stumped by a current simple formula giving inconsistent results. The wish is to calculate a percentile from one range based on criteria from another. The formula I'm using is (generically), =percentile(if(range1=cell,range2),.1) Range 1 and range 2 are named ranges of data, "cell" contains the criteria for range1. The problem is that the formula works fine for 50th, 75th and 90th percentiles but returns "-" when asked for a 10th or 25th. There are no zero's in the ranges but there are some blank cells. Is it possible that the formula is reading the blanks as zeros and therefor returning the null value? If this is the case is there a way to have the formula ignore the blanks?
Thanks for any suggestions that might help.
Peter
Thanks for any suggestions that might help.
Peter
