Filter Function with exclusions from a range

[Alex1234567]

I am trying to create a filter function that will exclude items that exist in a different range.
Something like:
=FILTER(A1:A5,A1:A5<>B1:B2)

Your help is appreciated

 

[StephenCrump]

Try:

	A	B	C	D
1	MyData	Exclude		Filtered
2	Apple	Banana		Apple
3	Banana	Apricot		Pear
4	Pear			Quince
5	Quince
6	Apricot
Sheet6

Cell Formulas
Range	Formula
D2:D4	D2	=FILTER(MyData,ISERROR(MATCH(MyData,Exclude,)),"Nil")
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Exclude	=Sheet6!$B$2:$B$3	D2
MyData	=Sheet6!$A$2:$A$6	D2

 

[Alex1234567]

Thank you. Works great.