Hi - Dave here.
Happy Friday!
Of all the new functions the Excel team has introduced in the last few years, I think the FILTER function is the most useful for the average user.
This is because FILTER, unlike XLOOKUP, returns
multiple results. This makes FILTER a very good way to isolate and inspect specific data without altering the original data.
But one challenge people run into with FILTER is how to apply more than one condition since there is just one
include argument.
The trick is to use something called
Boolean logic. This is easier to explain in an example, as seen in this short video:
[
Click to watch the video - 3 minutes]
For more examples and videos, see our
main FILTER page.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
