Using Quartile function on data with multiple conditions

[Kevyn]

I am trying to find the 25% (1st Quartile) on a set of data . However, I want to get the quartile base on ID (I have 51 different IDs) and a second category that is "0" or "1".

The problem I am having when using the quartile function is that I get the quartile for the entire range of data (6700 lines) and not just the quartile for the data that meets my conditions.

How do I set up conditions on teh quartile function so that it only returns the quartile for data that matches condition 1 adn condition 2. For example, I want the quartile for ID = 25 and condition 1 (Not the quartile for all of ID = 25 or all the data).

Thanks in advance

 

[maribelbc]

I filtered per centre and level and seems the quartile ranking is not consistent:

[TABLE="width: 447"]
<colgroup><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Centre[/TD]
[TD]Band[/TD]
[TD]Total Deals[/TD]
[TD]Days Worked[/TD]
[TD]Deals/Day[/TD]
[TD]Quartile Rank[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]168[/TD]
[TD]20[/TD]
[TD]8.4[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]36[/TD]
[TD]20[/TD]
[TD]1.8[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]74[/TD]
[TD]20[/TD]
[TD]3.7[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]64[/TD]
[TD]12[/TD]
[TD]5.3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]73[/TD]
[TD]12[/TD]
[TD]6.1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]122[/TD]
[TD]20[/TD]
[TD]6.1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]0.0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]213[/TD]
[TD]10[/TD]
[TD]21.3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]95[/TD]
[TD]20[/TD]
[TD]4.8[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]126[/TD]
[TD]20[/TD]
[TD]6.3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]146[/TD]
[TD]20[/TD]
[TD]7.3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]231[/TD]
[TD]20[/TD]
[TD]11.6[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]ESBCC[/TD]
[TD]7[/TD]
[TD]13[/TD]
[TD]0[/TD]
[TD]0.0[/TD]
[TD="align: right"]3
[/TD]
[/TR]
</tbody>[/TABLE]

11.6 and 6.1 are 2; and 1.8 and 6.3 are 1.

 

[AhoyNC]

I'm getting a different answer than what you show??

Excel Workbook
	C	D	E	F	G	H	I
1	Centre	Band	Total Deals	Days Worked	Deals/Day	Quartile Rank
2	ESBCC	7	168	20	8.4	3	4
3	ESBCC	7	36	20	1.8	1	1
4	ESBCC	7	74	20	3.7	4	2
5	ESBCC	7	64	12	5.3	4	2
6	ESBCC	7	73	12	6.1	1	3
7	ESBCC	7	122	20	6.1	2	3
8	ESBCC	7	0	20	0	3	1
9	ESBCC	7	213	10	21.3	3	4
10	ESBCC	7	95	20	4.8	1	2
11	ESBCC	7	126	20	6.3	1	3
12	ESBCC	7	146	20	7.3	4	3
13	ESBCC	7	231	20	11.6	2	4
14	ESBCC	7	13	0	0	3	1
Sheet