That's the best subject I could come up with. Couple examples to explain what I've been trying to do.
1. show all customers who do NOT have an address with Address Label = "Main"
2. show all customers who own a certain product but NOT another product
I've struggled to do this type of work in a single search. If I say "show all addresses where label != main," I just get all the other addresses (yes, that's obvious). And if a customer has only one address and it is "main," the customer is excluded from the results. I want the opposite. I only want to include customers in my results where they DO NOT have "main."
What I end up doing is running two searches (one to show ALL customers, and the other for customers who DO have "main"). Using VLOOKUP in Excel, I see which customers listed in the first search do not get a hit from the second search. This tells me who doesn't have a "main." It may sound complicated, but I can actually build these in about 5 minutes. The main problem is it's not nearly as portable as a search I can simply save and modify when someone asks me to add on some other columns.
Please somebody save me from myself. I'm sure I've been missing something so simple and obvious for a long time. If I can just figure this out, I'll know everything there is to know about life.