Hui, one of our in-house excel ninjas at Chandoo.org Forums, has asked an interesting question.
Microsoft is already planning the next version of Excel and is looking for our feedback into what extra chart types it should offer/include. [more]
It is an interesting question, so lets have a poll.
What new chart types you prefer to see next version of excel?
I would love to see box plots, bullet charts and dot plots.
What about you?
Use comments to share your views.
Btw, here are excel tutorials for creating bullet charts, box plots (box plot add-in) and dot plots (add-in).
PS: Only 2 more days before I close the net-book contest.
PPS: Only 3 more days before I close excel school registrations. Sign up today.
PPPS: Only 4 more hours before I shut down the laptop for weekend. Happy weekend 🙂
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).