Finding all categories that contain at least one value or a combination of values

I'm trying to figure out what the most efficient/easy way is to wind up with a table that has all instances of one column based on the criteria of any of those rows in another column.

Below are simplified examples, but the real data is hundreds of thousands of lines long, so I'm trying to figure out the most efficient way to do this. So, for example, if I have the below data set...

In one scenario, I would like to show all lines, for Persons who have ever had a negative transaction amount. Again, I'm not just looking to filter and show only rows with negative transactions, but rather to show rows for John Doe and Bob Smith, because they have had at least 1 negative transaction, and hide or delete rows for Jane Jones because she has not. I know it can be done with a number of formulas and helper columns, but is there any semi efficient way of doing it?

In another scenario with the same data, I may want to see all Person's transactions who have ever had a transaction with both a "Chevy" and "Toyota" (In this case, it would result in showing all lines for Bob Smith, because he's the only one with both Chevy and Toyota. (If it helps conceptually, think about a car dealership maybe wanting to pull up a list of all transactions for all customers that have had both "oil changes" and "tire rotations" (not just looking for those lines where they had the oil change and tire rotation, but all transactions for those customers who have had the combination of both services.

2016-06-09_18h07_31.png

Hope these scenarios make sense!

Anyone?