How to Use the FILTER Function in Google Sheets | Multiple Columns
Filter Function - This is a Google Sheet Formula you need to know!
What can the Filter function do? What if you'd like to lookup multiple criteria and return ALL match results? You can use Google Sheets FILTER function. You can return filtered results that meet your specified conditions which can be based on AND as well as OR conditions. You can also use the Filter function for multiple columns.
And because FILTER is a function its results are dynamic. In case you change anything in the data, the resulting filtered data will automatically update.
In this video I'm also going to show you how you can get your FILTER results sorted by putting the Filter function inside the Google Sheet Sort Function.
It's one of my favorite functions and if you are new to Google Sheets, it should be one of the first few functions that you should take a look at. Towards the end you'll find out the difference between the Filter Function in Google Sheets versus the Filter function in Excel.
Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets
*** Additional Bonuses are ONLY available on XelPlus.
Time Stamps
00:00 How to Use the FILTER Function in Google Sheets
04:20 FILTER Function with Multiple Columns
05:21 How to Sort Results in FILTER Function
07:08 Difference between FILTER in Excel vs. Google Sheets
⯆ Get your copy of the file here: https://www.xelplus.com/google-sheets-filter-function (scroll to the bottom of the article).
Google Sheets Tips and Formulas Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: 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!
#googlesheets
Видео How to Use the FILTER Function in Google Sheets | Multiple Columns канала Leila Gharani
What can the Filter function do? What if you'd like to lookup multiple criteria and return ALL match results? You can use Google Sheets FILTER function. You can return filtered results that meet your specified conditions which can be based on AND as well as OR conditions. You can also use the Filter function for multiple columns.
And because FILTER is a function its results are dynamic. In case you change anything in the data, the resulting filtered data will automatically update.
In this video I'm also going to show you how you can get your FILTER results sorted by putting the Filter function inside the Google Sheet Sort Function.
It's one of my favorite functions and if you are new to Google Sheets, it should be one of the first few functions that you should take a look at. Towards the end you'll find out the difference between the Filter Function in Google Sheets versus the Filter function in Excel.
Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets
*** Additional Bonuses are ONLY available on XelPlus.
Time Stamps
00:00 How to Use the FILTER Function in Google Sheets
04:20 FILTER Function with Multiple Columns
05:21 How to Sort Results in FILTER Function
07:08 Difference between FILTER in Excel vs. Google Sheets
⯆ Get your copy of the file here: https://www.xelplus.com/google-sheets-filter-function (scroll to the bottom of the article).
Google Sheets Tips and Formulas Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: 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!
#googlesheets
Видео How to Use the FILTER Function in Google Sheets | Multiple Columns канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![QUERY - Drop Down List to Filter Data - Google Sheets](https://i.ytimg.com/vi/nLW8SerwnJo/default.jpg)
![Filter Views - How to Filter Google Sheets Without Affecting Other Users](https://i.ytimg.com/vi/6IPgjcugp0g/default.jpg)
![5 Excel Functions YOU NEED in 2021](https://i.ytimg.com/vi/_EWcAR_Hkvg/default.jpg)
![Google Sheets - Filter Function Tutorial, Introduction to Logical Arrays](https://i.ytimg.com/vi/JQSlbQeEz1k/default.jpg)
![Excel FILTER Function TRICK for Non Adjacent Columns](https://i.ytimg.com/vi/Onudkw9DMlU/default.jpg)
![Advanced Excel Filter (And, Or, Between conditions for criteria range)](https://i.ytimg.com/vi/VqQACB_69SQ/default.jpg)
![10 Google Sheets Tips You DON'T Want to Miss (2021)](https://i.ytimg.com/vi/O0k9uE4xnD0/default.jpg)
![Google Sheets Advanced Tutorial](https://i.ytimg.com/vi/t0B0Tgz0b-0/default.jpg)
![NEW Feature! How to Use Smart Fill in Google Sheets](https://i.ytimg.com/vi/jz690myEAsw/default.jpg)
![Google Sheets - Find & Return Multiple Matches in Separate Columns, Rows or Comma Separated](https://i.ytimg.com/vi/_qEc8CEgUl4/default.jpg)
![Basic Excel Formulas and Functions You NEED to KNOW!](https://i.ytimg.com/vi/y1126PQ5zRU/default.jpg)
![Google Sheets - Dependent Drop Down Lists | 2 Ways](https://i.ytimg.com/vi/fGIb6mVvEMY/default.jpg)
![Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons](https://i.ytimg.com/vi/oSTgFUiRDGI/default.jpg)
![Excel Lookup to Return Multiple Values with FILTER Function](https://i.ytimg.com/vi/Eehk6PC0oGs/default.jpg)
![Google Sheets - Filter Views & SUBTOTAL Function Tutorial](https://i.ytimg.com/vi/49kkP04Whn8/default.jpg)
![Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel](https://i.ytimg.com/vi/mTdIEhtcqlo/default.jpg)
![5 Google Sheets Tips Every User Should Know!](https://i.ytimg.com/vi/3Ea_QXJlgN8/default.jpg)
![15 Functions in Google Sheets You NEED to know!](https://i.ytimg.com/vi/mRHlvRRERgs/default.jpg)
![How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)](https://i.ytimg.com/vi/XGvCT3IeYdA/default.jpg)
![Google Sheets BEATS Excel with THESE 10 Features!](https://i.ytimg.com/vi/n2DxXffRxBM/default.jpg)