NEW - EXCEL FILTER Function - Everything you need to know

Learn how to use the new FILTER Function in EXCEL.
Filter data and tables using multiple conditions including:

Filter(AND)
Filter(OR)
Filter(CONTAINS)

File Location:

Other Excel Playlists:

[Luciano_mp]

I like filter, good exemples, Thank you!

[chicachica]

Saved my life I was looking for this tut for hours

[tutsecret]

Is there a way to pick these criteria via combo box instead of typing because sometimes there are many criteria. Let's say I have to filter either Positive or Negative or No showed or Not tested or Refused test. Thank you for your concise video.

[rrdyhkk]

Could you please provide guidance on how to edit data within Excel filtered results? I'm interested in learning methods to manipulate and update data while working with filtered views in Excel. Any assistance or instructions you can offer would be greatly appreciated. Thank you!

[bilalgulmemmedov]

Hello, how to filter if it contains the value or name when we put two ages? for example in FILTER(AND) page you give two ages and it show all but i need it to filter only specific name.

[RareshCo]

What has to do isnumber formula i there?

[artemike]

how can i have more than one word in the "if contains example)? I am guessing you need to combine filtering word A, word B and the OR function somehow ? Like, in your example how can I filter results from two different states ?

[wohooky]

What about filtering if it DOES NOT contain a text, can we do that?

Thanks for the video!

[kaylak]

This is so helpful, and I'm getting closer to what I need, but I'm hoping for something pretty complex. Is it possible to search for results across multiple columns? I would like for my "search field" (H1 in your example) to be able to search across multiple columns of data. I've tried entering "A:D" in place of "D:D" in the search portion of the formula, but get #VALUE! when I do that and I tried "A:A*B:B" and so on, but then get "Nothing" and I'm stumped.

[hanyfahmy]

i need used filter function between 3 table at 3 different sheets .Sales 2022 .sales 2021 sales

[srinivasbonda]

But the formula is throwing only few values say, out of 10 only 5 values are appearing

[catboy]

So, we can also send a man to Mars but we really STILL can’t filter on multiple tables or in a table separated with blank rows? I have colleagues who love to stack tables or they use header rows or leave blanks. Can I use filter to get around this or does the data set need to be contiguous? Thx.

[tutsecret]

How about if I want this criteria to filter only the dates Opened Case column that is Today()-90. The sheet has 4k rows. Example: Today a nurse was assigned to a Case and she has 90days from today to give diagnose. So if Diagnose column is blank means the nurse did not provided yet the diagnose. So I have to filter all the cases that has blank diagnose counting 90 days back, there are many cases from 2023, 2022, 2021 including all the months and days and has not diagnose yet. So, show all the Opened Case Dates that Is null Or <Date()-90 with AND Diagnose column = "" or Is Null or "5", AND Dismissed Case = No. I am not sure if I use the formula <Date()-90 or =datedif(today()-90)) or if can be used either way. Thank you for your videos.

[calvinlong]

Everything? What about the =FILTER(array, {#, #, #, #, #, #}) # are 1 or 0