iGNORE N/A in filter function

Hello all

I am doing a lookup against anothger workbook using filter function:

=FILTER('[Tracker.xlsx]Tickets'!$A$2:$A$3714,'[Tracker.xlsx]Tickets'!$E$2:$E$3714="CB")

I have noticed there are N/As in column E on the source workbook (tracker). How can I edit my formula to return values ignoring #N/A? no values are being returned due to the #N/A value/s in column E on the source spreadsheet!

thanks

try:

Please Login or Register  to view this content.