Fantastic news folks…
As part of Office 2010 launch, Microsoft India is arranging a virtual launch event on May 25th and 26th. There are a ton of cool sessions on various Office products.
I will be presenting on “Sparklines and Conditional Formatting” On May 25th between 3:30 – 5 PM IST (we are GMT + 5:30). The event is free and open for all.
Click here to register for the event
Few more details about the event:
- You can join the session online or walk-in to one of the partner centers in India and attend.
- All the sessions are conducted by Microsoft India MVPs and Employees.
- Around 8000 people are expected to participate in the session
- All the participants are going to get an ebook and MS Certifications (I am not giving these, MS does, details should be provided during the sessions)
- For more details about Office 2010 Virtual Launch events, visit meraoffice.com
What will you learn in my session?
- Introduction to sparklines
- Introduction to conditional formatting (data bars)
- Learn how to apply sparklines and CF to a real world problem by building a simple dashboard
- Get URLs where you can download example files
Who should attend?
The session is good for anyone working with excel and upgrading to Office 2010 products in the near future. If you are someone responsible for deployment, purchase or training of Office products, then you might for the sessions very useful.
Any questions?
Drop a comment.
No questions?
Then go register… now!
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).