Conditional Quartile.INC function

Hi guys,

Can you help me please? I need your expertise.

Can I make multiple box plots based on one table? My tables resembles the one below:

Apple	4
Orange	2
Apple	8
Orange	1
Apple	2
Apple	9
Apple	3

How do I apply a condition to the QUARTILE.INC() so it picks up the numbers of Apple with Orange, without making another table?

::: UPDATE :::

So the Quartile function is: =QUARTILE.INC(array, quart). I need a formula for "array" to use specific cells correlated to Apple. Still trying...

Hi nzgin and welcome to the forum,

Assuming that your table start in A1, try this array formula

=QUARTILE.INC(IF($A$1:$A$7="Apple",$B$1:$B$7,"x"),1)

Note that array formula must be validated using CTRL + SHIFT + ENTER
The formula will create an array, keeping only the values correlated with Apple. Other are replaced by a letter and are not computed by the Quartile function.

Not sure I understand the mission.

Do these array formulae help?

If you aren’t familiar with array-entered formulae array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Row\Col	A	B	C	D	E	F	G
1			Quartiles	All	Apples	Oranges
2	Apple	4	Min	1	2	1	In D2: {=QUARTILE.INC($B$2:$B$8,ROWS($2:2)-1)}
3	Orange	2	25th	2	3	1.25	In E2: {=QUARTILE.INC(IF($A$2:$A$8="Apple",$B$2:$B$8),ROWS($2:2)-1)}
4	Apple	8	50th (median)	3	4	1.5	In F2: {=QUARTILE.INC(IF($A$2:$A$8="Orange",$B$2:$B$8),ROWS($2:2)-1)}
5	Orange	1	75th	6	8	1.75
6	Apple	2	Max	9	9	2
7	Apple	9
8	Apple	3