I have been bubbling with joy and excitement for almost 5 months now.. I don’t think I can hold it any longer. So here it goes,
We are becoming parents.
We have created a new cell and now that little cell multiplying fast. We are expecting the baby in first week of October.
It is very painful for us to stay in 2 different countries during such a beautiful and wonderful period. That is why I am going back to India tomorrow, for a 2 week vacation, to spend time with Jo. Now she is here and I am here
PS: That also means fewer posts during this break (I have scheduled some).
PPS: If you have some fun ideas on excel or charting and would like to write on PHD as a guest author, drop me a mail.
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).