Google Sheets FILTER function (multiple columns)

So, this is what the filter function does. Understanding it is pretty easy, where should I actually use it? Here are a few ideas:
- replace VLOOKUP and do a lookup to the left
- replace SUMIF or VLOOKUP when filtering on multiple criteria
- simulate what a pivot does and filter according to the contents from a cell

How do you use this function? Let me know in the comments.

[frankmorrow]

Hello Radu. I just want to say THANK YOU! This video helped me more than any other video on YouTube regarding using the filter function. This video actually solved all my problems and answered all my questions. I was really stuck - and your video gave me solutions. I am using this filter function for a Dashboard I created in Google Sheets as part of an inventory management system. The data is all located on the supporting sheets/tabs. I created a dynamic search box on the Dashboard for management and sales staff to look up our inventory by part #, series # or model # and find out what the item is and how many we currently have in stock of that item. Again, thank you for this very helpful video!

[maximepineault]

Hello Radu, in the last minute or so in this video, you use the filter function with one dropdown list as the criteria. Is it possible to add a second (or third) dropdown list as a second (or third) criteria? If so, can you please show me how this is possible?

[nrlacroix]

Radu, This is great, thank you for sharing. It is so close to being a solution to filtering my data. Do you know if there is a way to add criteria in the filter function as an "or" rather than an "and"? An example, that doesnt make complete sense in your data, would be if you have two columns of states, one order has two different states assigned to it. Then you want to filter all the orders that have Florida assigned. Some orders might have Florida in column f others in column g. Any thoughts would be greatly appreciated. Thank you again!

[DanielNetSet]

7:58 What I really would like to know is how to filter with SEARCH() from columns E and F using free text instead of the DropDown list

[GauravSrivastava-nomu]

Hi, This is good video but some time we need to filter based on some value but some time we need all data, How can we also include All in Region filter?

[velocitypta]

Thanks pls share practice file if possible

[eljinet]

So on Google Sheets I have this:

=iferror(FILTER('RAW DATA 2'!$B$2:$G, 'RAW DATA 2'!$B$2:$B>=$B$1, 'RAW DATA 2'!$B$2:$B<=$B$2), ""), the formula is working. However, I would like to skip a column from the range, my range goes from B2:G, I would like to skip column D from the range, how can I do it?

Thanks in advance.

[francoispoitevin]

Great vid!! Informative and all... Quick question, I try to filter (button) but it seem that my 19 000 rows are too many. Is there a maximum number of rows for filtering with buttons?

[samviews]

Good can we filter selective columns rather than all columns