E_DPSG
Board Regular
- Joined
- Jul 17, 2008
- Messages
- 82
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?
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?