Filtering data in one column using data from other column

Hello!

I have table that looks like this

Name Category Value
Martin Car YES
Peter Car YES
Peter Bike NO
Mark Car NO
Mark Bike YES
Max Car NO
Max Bike NO
Kenny Car NO
Kenny Bike YES
Kenny Boat NO

I need to filter this table so I will only find people, who only have NOs in all categories. In this example I need filter that will only show me Max.

Is there some way to achieve that? Thank you for help!

Hi

Select your data and use 'Format as table' or 'Insert Table' or use 'filter' from the menu.
Is that what you want?

See the file

No, unfortunately. Maybe I didn't explained it well. Sorry, english is not my native language.

I know how to use basic filters, but they can't help me in this case. I have huge amount of data in table I am working with. Probably around 50 000 people. And I need to filter only those people, who have NO in every category they have.
As I said on the original post - Martin has YES in Car category, i don't need him to be shown. Peter has NO in bike category, but YES in car category, i don't need him to be shown. And so on. I could use filter to hide all YESes, but then it would also show me people who have NO in some category and YES in other. That's not what I need. I need to see only people, who have NO in all categories. Like Max - he has NO in car cathegory and NO in bike cathegory. And he dosn't have any other category assigned - that's exactly one of people i need to find.

See if this help.
Try with a helper column E
Use the following formula and filter by that column

Formula:

Please Login or Register  to view this content.

See the file

Yes, that worked perfectly. Thanks both of you, you've been really helpful. Marking thread as solved.

You are welcome.

Thank you for the feedback and rep.