Google Sheets - Filter Function Tutorial, Introduction to Logical Arrays

Learn how to use FILTER function in Google Sheets. This tutorial will walk you through logical arrays and their use within FILTER function.

Practice file:

#googlesheets #googledocs

[wademartinishere]

YouTube should have a "Love" button. Excellent video!

[Українка-об]

Just wanted to say THANK YOU SOOO MUCH !!!! Spent 2 days looking for the information how to solve my task, and only your videos gave a clear answer and understanding.

[aaronanttila]

All your videos are incredible. Phenomenal teacher!

[claystudiofx]

everytime i watch every single video of you, everything looks so simple.

[moheuddin_sehab]

Such a amazing method. However you are more amazing. Your teaching method is phenomenal!

[sumayahghamdi]

Your way of teaching is really smart.
Thank you.

[ManojGuptahome]

excellent explanation of many hidden features of spreadsheet formulas. It makes my life easier and many things are doable now.

[StefanoVerugi]

Excellent work!
You remind me of Sal Khan in his early days, outstanding teaching method
So much appreciated

[RomeoTudose]

Is there a workaround to view data from a range using filter function but also to be able to change data in the filtered data row/col ?

We have sheets with thousands of rows so we use filter function in a parallel sheet to get to the values we wish to analyze. But often we also need to change a value in those filtered values which means going back to the master sheet, search for the row and then modify the value / values
I'm sure there must be a better way 😉

Thank you for your efforts in making some extraordinary good tutorials

[robertmaluka]

To do a short cut on a array "Ctrl+Shift+Enter. This was a very good video. I learned a few new tricks. For and "OR" I would use a column and get my true false. then filter it off that. Everything was very understanding. Now I have to learn a few new things. Thank you

[sugumarsit]

This video really helps me what I want. Thank You

[akahatapodcast]

You are a great teacher. Thanks for the video!

[XCelVietnam]

Thank you a lot, the clip is long but very thoroughly shared

[alansavage]

Thanks. Going play around with it. My most common challenge is filtering/matching/extracting data from 2 or more sheets.

[yashavantpatel]

Very very helpful 👍. Thank you so much 🥰.

[enhancedcalm]

Really good video. Working with a practical dataset helped make it clear.

[ihgaming]

very nice video. how do you do it if the second condition is on a different column? for example: column A is where the unique values, column B is the lead name, column C is the product. what I want to do is to get all the values in column A, given the condition set is from column B and column C

[abhinavm]

This tutorial are awesome, thank you bro, it helped me a lot, thanks again

[hoiyinwan]

Thank you for your lesson! It is much appreciated!

[jamieheiney]

Thanks for including the practice file!