Quintiles - based on sub groups

[E_DPSG]

I am having a brain block this morning. I am trying to break down segments of data into quintiles based on two fields: ColB and ColC.

ColB has a subgroup of East, West, North, South

ColC is a numeric value that the quintile will be based on.

What I am seeking to do is see the quintile ranges based on the East, West, North, South.

I am using PERCENTILE($C$11:$C$2997,0.20), etc to get the quintile of the entire group, but cannot place the match or index in the correct place to get the desired result.

Any advice?

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=PERCENTILE(IF($B$11:$B$2997="North",$C$11:$C$2997),0.2)

 

[E_DPSG]

Ahhh.... and we are all good..... Thank you sir.

 

[Domenic]

You're very welcome! Thanks for the feedback!