I am using the offset formula to be used as a source reference for my percentile formula.
=OFFSET($A$1,(MATCH("ANZ",$A:$A,0))-1,2,COUNTIF($A:$A,"ANZ"),0)
However, i keep getting the #REF error.
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
What i wan to do is to find the 95th percentile of column C provided column A is ANZ.
i was trying to write a dynamic data source.
Thanks.
=OFFSET($A$1,(MATCH("ANZ",$A:$A,0))-1,2,COUNTIF($A:$A,"ANZ"),0)
However, i keep getting the #REF error.
A | B | C |
ANZ | 444 | 10 |
ANZ | 333 | 87 |
ANZ | 555 | 34 |
ANZ | 666 | 13 |
ANZ | 678 | 12 |
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
What i wan to do is to find the 95th percentile of column C provided column A is ANZ.
i was trying to write a dynamic data source.
Thanks.