Quote Originally Posted by xld
This will work for PERCENTILE90 for your dataset

=$D3=MAX(IF(IF(
($B$3:$B$64=$B3)*($C$3:$C$64=$C3),$D$3:$D$64)
<PERCENTILE(IF(($B$3:$B$64=$B3)*($C$3:$C$64=$C3),$D$3:$D$64),0.9),
IF(($B$3:$B$64=$B3)*($C$3:$C$64=$C3),$D$3:$D$64)))
xld, that formula refers to column D - what's in it?