Filter function using a hard coded string of values in include.

[HighAndWilder]

I've forgotten the syntax for using the FILTER function where the include values are in a hard coded array.

Formula in G1 obviocly not working.

Thanks

Extract the word which carries the specific text.xlsm
	A	B	C	D	E	F	G
1	Fruit	Qty	Sell	Total			#VALUE!
2	Orange	16	£57	£912
3	Apple	87	£39	£3,393
4	Apple	61	£39	£2,379
5	Orange	41	£57	£2,337
6	Melon	88	£92	£8,096
7	Banana	89	£46	£4,094
8	Orange	20	£57	£1,140
9	Apple	40	£39	£1,560
10	Grape	38	£10	£380
11	Banana	33	£46	£1,518
12	Orange	70	£57	£3,990
13	Orange	94	£57	£5,358
Sheet2

Cell Formulas
Range	Formula
G1	G1	=FILTER($A$2:$A$19,$A$2:$A$19={"Apple","Banana"},"")

 

[Fluff]

How about

=FILTER($A$2:$A$19,ISNUMBER(XMATCH($A$2:$A$19,{"Apple","Banana"})),"")

 

[HighAndWilder]

How about

=FILTER($A$2:$A$19,ISNUMBER(XMATCH($A$2:$A$19,{"Apple","Banana"})),"")

Thanks Fluff. Can always rely on you.

 

[Fluff]

You're welcome & thanks for the feedback.