Almost an year ago, my life took a pleasant, awesome turn. I became dad to two beautiful, naughty and energetic kids. We named them Nishanth & Nakshatra (meaning Moon & Star). Ever since they entered our world, our lives have changed. They bring laughter, love, anxiety and curiosity to our life everyday. And this Friday (24th Sept), they will be one year old.
To mark the occasion, we are having a mild extravaganza at our home in Vizag, India (here). I would be very happy if you can join us and bless our babies on this occasion.
If you are planning to come, just drop me an email at chandoo.d @ gmail.com and I will email you address and details.
Thank you.
3 Responses to “Filter one table if the value is in another table (Formula Trick)”
What about the opposite? I want a list of products without sales or customers with no orders. So I would exclude the ones that are on the other table.
Good question. You can check for the =0 as countifs result. for example,
=FILTER(orders, COUNTIFS(products, orders[Product])=0)
should work in this case.
PS: I have added this example to the article now.
Hi there!
Could i check if there was a way to return certain fields of the table only?
so based off your example above, i would like to continue to use the 'Products" table as a way to filter out items from my "Orders" table, but only want to show maybe only the "Product" and "Order Value" fields, rather than all 5 fields (sales person, customer, product, date, order value).