Excel Office 365: 'not equal to' doesn't work in advanced filter

Question

I have a database and use Advanced filter to extract requiered data. Technically it works fine, that is, when the criteria are like this:

But when I change Criteria3 to <>40010, like this:

I get the correct data, <> 40010 from Criteria3, but still also data that meet the first Criteria3 =40010. I've tried every combination of the 3 criteria I could think of, and all was well as long I didn't use <>. Which I don't understand. Could someone please help me with this?

This is an edit answering the question from Louis: "The condition that you entered in the criteria cell, we only see the result of the formula."

This is what works:

And this is what doesn't work:

Is this what you ment?

Answer 1

Have you tried <>40010 instead of ="<>40010"