get rid of 0's in unique/filter formula

[smking204]

here's my formula to find everything in column E that is not in column A:

=UNIQUE(FILTER(E$3:E$500, ISERROR(MATCH(E$3:E$500, A$3:A$500, 0))))

it includes a zero every time, since it is counting the unused blank cells (I usually only have around 200 items or so in each column). I've tried nesting a second filter within the filter, like this:

=UNIQUE(FILTER(FILTER(E$3:E$500, E$3:E$500<>""), ISERROR(MATCH(E$3:E$500, A$3:A$500, 0))))

but I get a value error. Any suggestions for eliminating the zeros at the formula level? I'd rather not do any special formatting to erase them, I'd like for them to not be included at all. Thanks in advance!

 

[Fluff]

How about

=UNIQUE(FILTER(E$3:E$500,(E3:E500<>"")*(ISERROR(MATCH(E$3:E$500, A$3:A$500, 0)))))

 

[smking204]

How about

=UNIQUE(FILTER(E$3:E$500,(E3:E500<>"")*(ISERROR(MATCH(E$3:E$500, A$3:A$500, 0)))))

that was exactly it! turns out that was explained on the exceljet page, I just didn't read far enough. Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.