Filter Function ignoring #n/a

[mart_mrexcel]

i have filter formula to filter an apple but it is returning as "#n/a" because somewhere in column $b:$b has an error, how can i ignore the any error in that column and filter as per the criteria.
=FILTER($A:$A,$b:$b="apple")

 

[jorismoerings]

Hi,

try this: =FILTER($A:$A,IFERROR($b:$b="apple",0))

 

[mart_mrexcel]

Hi,

try this: =FILTER($A:$A,IFERROR($b:$b="apple",0))

That works, thank you.