How to Use the FILTER Function in Google Sheets | Multiple Columns
HTML-код
- Опубликовано: 31 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover how to skillfully use the FILTER function in Google Sheets for sophisticated data management. This function not only returns multiple matches but also ensures your results are always up-to-date. Perfect for filtering data based on one or multiple criteria, and you can even sort your results with ease.
⬇️ Get your copy of the file here: pages.xelplus.com/filter-shee...
🔑 Key Takeaways:
▪️ Dynamic Data Filtering: Easily filter data based on varying criteria with real-time updates.
▪️ Multi-Column Filtering: Apply filters across multiple columns to refine your data analysis.
▪️ Automatic Sorting: Learn to sort your filtered data in ascending or descending order, adding an extra layer of organization.
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.
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.
Join My Google Sheets Comprehensive Masterclass: www.xelplus.com/course/google...
*** Additional Bonuses are ONLY available on XelPlus.
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
Google Sheets Tips and Formulas Playlist: • Google Sheets Tips, Tr...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
Grab the file I used in the video from here 👉 pages.xelplus.com/filter-sheets-file
I had been struggling to create a more automated workflow for my tutoring business finances until I found this video. This was awesome and just what I needed!
Yet another great video. Well done. I watch these for the subtle nuances. Little things that i really didn’t think about.
You are a fantastic teacher, Leila!
This is really helpful and easy to understand. Thank you!
Excellent tutorial as usual, thank you!
oh perfect! this is EXACTLY what i was looking for! thank you!
Awesome as always
Extremely helpful, thanks!
Your Filter formula is useful for me. Thank you.
I HAVE STRUGGLED ALOT UNTIL I FOUND THIS VIDEO TO AUTOMATE COPY A SET OF ROWS TO OTHER SHEET , HELPED ME A LOT MADAM, THANKS A LOT
Thaaanks.
I've been trying to use vlookup, indirect, index, match to acquire the same result as this filter function. Now this makes a lot easier. Thank you so much.
Awesome tutorial, thank you.
This is so helpful.. thanks a lot Leila!
The multiple conditions feature is nice. Wish Excel had that. Great tutorial
That was supper helpful and such high quality! Thanks for sharing!!
Glad it was helpful! Thank you.
Really nice video, helped me to solve lots of issues, hats to you Leila
I have been looking for this for years! Thank you thank you thank you.
Glad I could help!
Thank you 🙏 instructive
Amazing Explanation! It's clear now :)
The best for my food cost automation calculator! thank you
😍
Thank you, That's really helpful.
Super super useful thanks a lot!
THank you so much! This is a life saver!
Thanks, you make me look like a hero at work
Brilliant as always. Leila thank you for a wonderful video.
Glad you enjoyed it!
Excellent ... The only reason i didn't wanted to shift from excel to Google was filters but now i m in ... Thanx for this great video 👍
Thank you so much for your help
thankyou so much.. i couldnt explain what i wanted and spent a lot of time searching online until i landed on this!!
Great to hear!
Awesome video! Thank you!
Your content is more than great! you have been help me so much with all your tutorials :D
Happy to hear that, Georgina!
I really appreciate your many recent Google Sheets videos. I also like the suggestions you make for its improvements. I hope Google is listening.
Glad you like them Derek!
THANK YOU - Have have watched 10 videos trying to find somebody to show me how to do this!!!!
Glad it was helpful!
This was very helpful, so glad this is up on youtube.
Glad you enjoyed it!
Thanks for the awesome video!!!!
Excellent explanation, thank you for the help! (:
Your videos are very nicely edited, it's cool!
Thank you very much!
Hi Leila - Can you hide columns in filter views? Let's say I have a column just for staff / internal use and I want to share a filter view with a client.
Hi, Leila! Thank you for this helpful video! Your course is definitely on my list of to dos!
Trying to build an internal inventory management system using Google Forms and sheets. Trying to combine two tabs onto another tab using two filter functions. I got that working. But I can’t seem to get the optional drop-down menu filter sections to tie in with the filtered summary data. For example, If the filter option for “Seller” has text value, I want the table with the two filter functions to update the filter based on what seller is in the filter drop-down. But the issue I think is some items have more than one seller each on their own line of text within a cell. So I don’t think the filter function will read partial text from the Seller column… :(
Anyone happen to have in insight on this?
Greate tutorial Leila!
Great vedios and well explanation.help me a lot for crack my exam and assignments.thanks a lot❤️
Perfect, go ahead boss
Hi Leila, can we also include the Region column in the below output
I have date filter instead of Region column but i want the data with Date column as well. can you please help
Hey Leila,
I was wondering if we can arrange multiple columns in filter function
Like sortby function in excel
These videos are awesome! Thanks so much. I'm using them in my classroom to filter and sort student responses to various tasks. But, I find that as more students add their responses, I have to manually adjust my filter formula to include the new line of data added to the top of the spreadsheet because I have a reverse sort for column A (Timestamp) so I can see the newest submissions first. Is there a way to NOT have to manually change my filter formula every time?
Thanks Leila ... this is perfect
Glad you like it!
Hi, I am using Google Sheets and want to use the filter option. In my case I would like to filter all columns (let's say from B to S) for a specific date (eg. 28.10.21) and return the value in column A (there could be the name). To not get the same name multiple times I already use the unique() function. But I can't get the filter() function to work. Is there anyway of doing that? Thank you =)
Very helpful Leila!
Thanks for dropping by Chris.
This is awesome how this is all possible in google sheets. Also before watching this video an ad for actual bedroom sheets was shown😂 I guess they took the keyword “sheets” literally haha.
😂 the RUclips algorithm has some work to do... or maybe they know what Google Sheets users really need 😉
@@LeilaGharani haha I thought it was pretty clever advertising😂 also always impressed with your video editing. I know it might be off topic, but it might be cool to see a behind the scenes video on how you make such clean videos. Definitely trying to learn how to up my game in that department :)
thank you for your tutorial.
Welcome 😊
thanks teacher.
Leila, As usual its excellent. You are rocking.
Thank you! 😃
i am so happy after watching this video and before watching this video . about filter function in google sheets . the only helpfull tutorials that make my life way easier . o'h i shall not worry leila has got ton's of more awesome tutorials like this in the future...............😁😁
Great 👍
Great, this is what I looking for, but may I know can i add another condition at another dropdown list? so that I can have filter the same roll with two condition. appreciate if you can advice on this.
IT was a great video. Please keep bringing more google sheet videos. Thanks
Thanks, will do!
very helpful and nice video - I am using a sort filter formula to get the top 10 values of a column, but there are some texts or n/a in this column - Does anyone know how I can exclude them all?
THANK YOU. JFC this saved me some time. /subscribe
Glad to have you aboard!
Mam your presentations are always very perfect and well arranged ...
👌👌👌
So nice of you :)
Would it be possible to filter inside the data set itself using the dropdown instead of creating a new table? I tried to use filter mode and write a condition where I was pointing to the fact the data should be greater than a given cell but it does not work, just work if I use a given number directly.
I thank you for your well spoken and understandable language madam. Am from Uganda-Africa
Glad you like the video Bruno :)
thanks for this useful video
You are most welcome
Great vidéo ! Could you explain how do you do when the FILTER function return "no result" with google sheet ? basically how do we replace the "IF_EXISTS" from excel ... Thx !
Hi Leila,
Is there option for table to share from different location like url. Or other options. I don't want to show entire data table in the excel & want to search data on conditional filter n only show 2 column only..
Thank you Leila for this wonderful course. I want to kindly request that you further add date filter to the course like from 1/1/23 - 31/12/23. Thank you
Hi @LeilaGharani, is there have a way to filter 2 things, like have two drop-down chooses.
Is there a general rule to determine when it is more appropriate to use the FILTER function rather than the QUERY function?
How to do it if I want to add another condition on a line ? (in addition in the 2 conditions n the column)
How do I set the range then ? (as the height has to be identical!) 🤔
Hello Mam, I have a huge sales database in excel having multiple details like invoice number dates etc, for these daily collections o have created a Google forms with my required column. My question is is there any possibility to look in to only with the existing outstanding invoice details alone in a Dropbox while the entering in the Google form.
I have a rota for 50 members of staff and I am trying to create a formula which gives me the names of all the people on a specific shift on any given day. such as the names are on column A and the shifts for that day may be on column D. Which formula would I use to do this and is it possible?
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
what add on can use in sheets to be able to see the function information like it shows around @2:05
Hi this video is so informative, May I know is there any formula to add total sales amount for each country we select ? It would be a great help
Very good information. Now, I am return back from hospital. Thanks for your good wishes. You have make very good videos on google sheets. Videos on Comparison of google sheets Vs Office 365 are interesting. It is my hobby to see these videos.
Glad you're feeling better.
Hi Leila, great video and extremely easy to follow. A question for you, what if I wanted to add a sum for the profit column which will be dynamic i.e change when you select a region. Do I need to use a condition or just a simple sum function? Thank you!
My guess Subtotal(9,range) e.g. Subtotal(9,E2:E)
I just found your videos, and they are super! If i may ask, can i use the filter function from another google sheet? I mean a different google sheet file? Would that be possible?
Hi. Thanks so much you make it look very easy!
Can I have an "ALL" drop down filter?
Is it possible to search and filter on text inside NOTES as part of the search criteria?
Very nice thank you for share
Thank you too
From your video I noticed that Goggle dynamic formulas have a great feature for expandable range without need to convert data into a table. Although I like tables, but there is something to improve for Microsoft
Hi Vida. Agree - I like that too. It makes it easier to type in the formulas.
Sweet flower 🌷
Hi.I want to know how to create form QR Code scanner in Vba Excel by use Webcame?
I need the code to create it.
After we use Webcame Scan it already I want the result in QR code to textbox. Thank beforehand.
great video. do you have a video telling what the difference between google and ms sheets are?
I have cells in table B that equal cells in Table A... a filter is applied to Table A and all the numbers get rearrange, because of this the values in Table B also change, I don't want the values in table B to change, i want the cells in table B that i have linked to table A to always show the original values of the cells they were linked to regardless of the filtered arrangement... so my question is how do I keep the cells in table B that have been linked to table A to follow the original values before the filter was applied?
How i can filter 2 or more region at the same time? In other words, i want to filter the results of Europe and Australia at the same time.
What if we want ALL region , in Drop down if add "ALL" What is the changes need to do on filter formula ?
how can I filter data to sheet 1 (Master data) to sheet 2 ? is this formula work then? i need your help
Thank you liela, can you teach us how to combine multiple filter array, in Google sheet there is simple way to combine multiple arrays by using { }, but in excel I'm confused
Incase while using this function you need to filter dynamic columns. In this case for eg: App and Profit.
Then the formula should be -
=SORT(FILTER({C5:C,E5:E},B5:B=H6,D5:D>0,2,TRUE)
You can arrange the columns however you want
For eg: If you need Division and Profit
=SORT(FILTER({A5:A,E5:E},B5:B=H6,D5:D>0,2,TRUE)
There is a video for this by the same channel on how to do it on Excel and its quite different. Also, many people found it useful. For people who heavily depend on Google Sheets hope this helps.
Thanks for your feedback Viraj!
Mam, your video is simple and informative. Thanks. Your beautifulness is increase with time !!! Howzat !!!
Thanks a lot 😊
How can I filter from two ranges by wo conditions, but bring all results in one column just like when I have one range. Is it possible by Filter or there is another way?
is there a way to include in your region filter a value that returns all regions?
Can be use at a time google Excelsheet filter use multiple user
great video, but if I have more then two conditions in one column how could i get it? for example, I have this column DS_occupied have two condistion as shown below?
=FILTER( { DS_model, DS_flate, DS_colour, DS_DateEnd } , DS_occupied ="AV", DS_occupied ="Not Found")?
How do I select region and information between two dates
please guide if possible.
So i did the forumlar, no errors. I can see the drop down list but no data transfers over
Possible to see the results in another tab in the same worksheet?
Leila, how to make a drop down menu, and box display and dding buttons on a page to display desired results. thnx
thanks.
Hi Leila,I have also joined ur course on udemy I want to know how the filter function will return headings dynamically in Google sheets it works with vstack function in Excel. How It will work in Google sheets.
Hi, i have a project i am working on, and i would like a consult if possible, what is the process to get a consultation session with you for 10 minutes?