Percentile and if statement

[bluepenink]

Hi all

I have offices listed in range I14:I950
I have sales listed in range O14:O950

so i want to apply the 25th percentile number to the bottom third of the people; the median (50% percentile) number to the middle third of the people and the 75th percentile number to the top third of the people? - can this formula be unique by location? i want to exclude 0s and blanks

I have this previous formula

=IF($O14=0,"",LOOKUP(PERCENTRANK(IF(($I$14:$I$960=$I14)*($O$14:$O$960<>0),$O$14:$O$960),$O14),{0,0.25,0.75,0.9},{"","25th","75th","90th"}))

but dunno how to modify it so it provides 25th percentile to bottom 1/3 of ppl, 50th percentile to middle 1/3 of ppl and 75th percentile to top 1/3 of the ppl, in the range?

thxs so much!

 

[bluepenink]

any thoughts on this guys?