That is right. Next week is your week on this blog. I will post content that is shared by you. So go ahead and share your tips and tricks with us.
It is a great way to interact with the community at PHD and give a little back. I didnt know cell from pivot in 2006, but when I started blogging, just by sharing the little I know I ended up learning a lot. It is such a joyful experience and I want you to feel it too.
How can you share your tips?
We have set up a google web form to capture all your tips: click here to submit your tips for your week at PHD
Alternatively you can comment on this post with your tip, or email me at chandoo . d@ gmail.com with your tip.
Make sure you indicate your name, email, website / blog url and the tip in the email.
What are the themes around which you can submit the tips?
You can submit tips on,
- Excel formulas
- Excel Charting
- Shortcuts and Productivity
- Formatting, Printing etc.
- Using Excel – Rest of the stuff
What happens to the submitted tips?
Next week (between 11th and 15th May) everyday I will share all the tips submitted by you with the entire community at PHD. That is almost 5000 people (3500 using RSS and another 1500 regulars at website) waiting to read what you have got to say.
Go!
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).