In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.
What is in this session?
This session has 2 things.
- A surprise Easter egg (an Excel tip hidden in the podcast audio)
- Collection of Excel tips recorded & submitted by Chandoo.org readers
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Keyboard & Mouse shortcuts
Chart formatting tips:
Transcript of this session:
Download this podcast transcript [PDF]
Did you find the Easter egg?
Now that you found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.
Thanks to the contributors
Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from 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).