How to FILTER with Multiple Criteria in Excel #shorts

In this video, we’ll set up the FILTER function with two criteria in different columns. Both of these conditions have to be met (AND) for the result to be included. If you're searching for how to FILTER your data with multiple criteria, this video has the answer. If you need OR criteria, for example looking up two different values within the same column, you'll need to use the PLUS operator.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[joevano]

I think it is helpful to understand that true = 1 and false = 0, which is why you multiply for AND and add for OR. Going the other direction 0 evaluates to false and not 0 is true. Knowing this helps for all kinds of excel “tricks”.

[dougidoug]

Of course Walter gets an A in chemistry. After all he is the best cook.

[travisos]

Thank you very much, i needed this video 🙏

[justinriehl]

The only drawback to this is it only works if you have only 2 things to filter. Not for more. I had to get really creative to have 3 or 4 filtering criteria

[Slyh]

a much more straightforward approach is to turn data into a table and use slicer.

[excelenko]

I always use + and * instead of "AND" "OR" - works fine!

[themadhiker]

You’ve literally just saved my life with this 🤣

[CallumPooleProgrammer]

Or in SQL:
SELECT Student FROM Table WHERE chemistry='A' AND geography='A'

[armin]

I typically compare the concatenated string - using the function or & but I guess this is more elegant. 😊

[alihms]

Was excited for this info. Only to realise my work pc is still on Excel 2016 :-(

[mulisaurus]

This is great...I use another way of incorporating Index Match but this seems slightly more simple to use.

[jayeshdhuri]

How to display data from two different sheets using filter function specifically when the condition is " or " either in 1 sheet or second sheet

[Envy_Alvin]

From my experience using Let Function and 2 Filter Formulas so that you could amend the criteria easily to suit any changes needed to made.

[theworldbroker]

give more about connecting multiple tables in one slicer.

[jygysxt]

No one struggles with this, i promise you, and this 'solution' is only for comparing two columns.

[sachinrv]

One who has used the sumproduct can easily relate to this..

[storywha]

Hi Leila,
I really love your tips.
I have for you that looks similar to this.
I have a lottery syndicate with 20 members.
They all have different numbers so how do I get excel to highlight when a number drawn matches one of theirs on a weekly basis?

[kiragi]

I multiply results from logic checks all the time. Sometimes in nested Index(match(index())) format. In situations where I can use FILTER instead, it should massively reduce the processing load on excel. Thanks!

[annog]

The or condition only works if the conditions never occur simultaneously... because it just adds up 1s and if you go to 2 it breaks. Please mention that somewhere it can lead to serious errors.