How to Use the FILTER Function in Google Sheets | Multiple Columns

Поділитися
Вставка
  • Опубліковано 13 січ 2025

КОМЕНТАРІ • 209

  • @LeilaGharani
    @LeilaGharani  11 місяців тому +3

    Grab the file I used in the video from here 👉 pages.xelplus.com/filter-sheets-file

  • @deemon710
    @deemon710 21 день тому

    It's ridiculous how exited I was to learn this. Thanks!!

  • @zaralaisradgemonteiro8260
    @zaralaisradgemonteiro8260 3 роки тому +5

    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!

  • @go2mac
    @go2mac Місяць тому

    Thank you Leila. Always love the education. Yes Excel does differently.

  • @PraveenKumar-ms7kc
    @PraveenKumar-ms7kc 7 місяців тому

    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

  • @pastryboy714
    @pastryboy714 Рік тому +1

    The best for my food cost automation calculator! thank you
    😍

  • @germaincharlie2277
    @germaincharlie2277 3 роки тому +1

    Really nice video, helped me to solve lots of issues, hats to you Leila

  • @TylerStanczak
    @TylerStanczak 4 роки тому +15

    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.

    • @LeilaGharani
      @LeilaGharani  4 роки тому +2

      😂 the UA-cam algorithm has some work to do... or maybe they know what Google Sheets users really need 😉

    • @TylerStanczak
      @TylerStanczak 4 роки тому

      @@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 :)

  • @birasafabrice
    @birasafabrice 5 місяців тому

    Excellent tutorial as usual, thank you!

  • @dashcamvids
    @dashcamvids 11 місяців тому

    thankyou so much.. i couldnt explain what i wanted and spent a lot of time searching online until i landed on this!!

  • @systemssde3405
    @systemssde3405 2 роки тому

    Your Filter formula is useful for me. Thank you.

  • @gracemark5995
    @gracemark5995 4 роки тому +1

    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...............😁😁

  • @leitzagorman9248
    @leitzagorman9248 2 роки тому

    Extremely helpful, thanks!

  • @ivanurbina2422
    @ivanurbina2422 2 роки тому

    Awesome tutorial, thank you.

  • @greggowaffles
    @greggowaffles 4 роки тому +1

    That was supper helpful and such high quality! Thanks for sharing!!

  • @Flying_Scorpion
    @Flying_Scorpion Рік тому

    This was very helpful, so glad this is up on youtube.

  • @INDIA44329
    @INDIA44329 4 роки тому +1

    Mam your presentations are always very perfect and well arranged ...
    👌👌👌

  • @TheSnowfarmer
    @TheSnowfarmer 3 роки тому

    You are a fantastic teacher, Leila!

  • @nssdesigns
    @nssdesigns 2 роки тому

    Thanks, you make me look like a hero at work

  • @MaggieBernard3
    @MaggieBernard3 3 роки тому +2

    This is really helpful and easy to understand. Thank you!

  • @Prasadtr
    @Prasadtr 2 роки тому +2

    What if we want ALL region , in Drop down if add "ALL" What is the changes need to do on filter formula ?

  • @hamedalizadeh8782
    @hamedalizadeh8782 3 роки тому

    I have been looking for this for years! Thank you thank you thank you.

  • @pavithragokhale1424
    @pavithragokhale1424 Рік тому

    This is so helpful.. thanks a lot Leila!

  • @sahilmanocha
    @sahilmanocha 3 роки тому

    Your videos are very nicely edited, it's cool!

  • @kunjalchawhan6658
    @kunjalchawhan6658 2 роки тому

    Amazing Explanation! It's clear now :)

  • @johnvalleytube
    @johnvalleytube Рік тому

    Super super useful thanks a lot!

  • @sarfdhillon
    @sarfdhillon 8 місяців тому

    Awesome as always

  • @Astral_Ocelot
    @Astral_Ocelot 3 роки тому

    oh perfect! this is EXACTLY what i was looking for! thank you!

  • @DerekBlais
    @DerekBlais 4 роки тому

    I really appreciate your many recent Google Sheets videos. I also like the suggestions you make for its improvements. I hope Google is listening.

  • @eljinet
    @eljinet 3 роки тому +1

    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

  • @AccountingandQuickbooks
    @AccountingandQuickbooks 4 роки тому

    Very nice thank you for share

  • @scienceenthusiastplaygroun3496
    @scienceenthusiastplaygroun3496 2 роки тому

    THank you so much! This is a life saver!

  • @aaronfist3419
    @aaronfist3419 3 роки тому

    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.

  • @sachinkalra6078
    @sachinkalra6078 2 роки тому +2

    Hey Leila,
    I was wondering if we can arrange multiple columns in filter function
    Like sortby function in excel

  • @panupong9278
    @panupong9278 2 роки тому

    Thank you, That's really helpful.

  • @westernugmedia.1305
    @westernugmedia.1305 4 роки тому

    I thank you for your well spoken and understandable language madam. Am from Uganda-Africa

  • @nadeemmalik8031
    @nadeemmalik8031 4 роки тому

    Brilliant as always. Leila thank you for a wonderful video.

  • @davidtmiller56
    @davidtmiller56 3 роки тому

    Yet another great video. Well done. I watch these for the subtle nuances. Little things that i really didn’t think about.

  • @NathanielStockwell
    @NathanielStockwell Рік тому

    Excellent explanation, thank you for the help! (:

  • @SurfingBetweenAtoms
    @SurfingBetweenAtoms 4 місяці тому

    Great video :)
    I'm just wondering if it is possible to use another conditions, but not linked with other condition like logical "and", but rather like logical "or". To have more results, not less.

  • @Bikman
    @Bikman 3 роки тому

    thank you for your tutorial.

  • @mohammedabid3731
    @mohammedabid3731 3 роки тому +1

    nice vedio

  • @dimitrisblane6368
    @dimitrisblane6368 Рік тому

    Hi. Thanks so much you make it look very easy!
    Can I have an "ALL" drop down filter?

  • @sethumadhavan375
    @sethumadhavan375 4 роки тому

    Leila, As usual its excellent. You are rocking.

  • @MarkPhillipsgms
    @MarkPhillipsgms 11 місяців тому

    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?

  • @kctinternet
    @kctinternet 2 роки тому

    Thank you so much for your help

  • @tundeodebunmi6333
    @tundeodebunmi6333 Рік тому

    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

  • @AJ-et3vf
    @AJ-et3vf Рік тому

    Awesome video! Thank you!

  • @shaykh_dubai
    @shaykh_dubai 3 роки тому

    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 👍

  • @genessymendoza4066
    @genessymendoza4066 4 роки тому

    Thank you 🙏 instructive

  • @georginamoron5345
    @georginamoron5345 3 роки тому

    Your content is more than great! you have been help me so much with all your tutorials :D

  • @yasufumithebest
    @yasufumithebest 2 роки тому

    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.

  • @fabiolaverduga
    @fabiolaverduga 3 роки тому

    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?

  • @nasuhamazlan4862
    @nasuhamazlan4862 8 місяців тому

    Hi @LeilaGharani, is there have a way to filter 2 things, like have two drop-down chooses.

  • @Layarion
    @Layarion Рік тому

    great video. do you have a video telling what the difference between google and ms sheets are?

  • @patrickschardt7724
    @patrickschardt7724 4 роки тому

    The multiple conditions feature is nice. Wish Excel had that. Great tutorial

  • @chrism9037
    @chrism9037 4 роки тому

    Very helpful Leila!

  • @nitu0606
    @nitu0606 6 місяців тому

    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..

  • @meghaanil3740
    @meghaanil3740 4 роки тому

    Great vedios and well explanation.help me a lot for crack my exam and assignments.thanks a lot❤️

  • @HusseinKorish
    @HusseinKorish 4 роки тому

    Thanks Leila ... this is perfect

  • @rajsahu1029
    @rajsahu1029 4 роки тому

    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.

  • @mohaiminkader6634
    @mohaiminkader6634 4 роки тому

    IT was a great video. Please keep bringing more google sheet videos. Thanks

  • @OddvinAlmenning
    @OddvinAlmenning 3 роки тому

    Greate tutorial Leila!

  • @alphabeta01
    @alphabeta01 2 роки тому +1

    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!

  • @virajwaghmare4488
    @virajwaghmare4488 4 роки тому

    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.

  • @osamasaid8476
    @osamasaid8476 4 роки тому

    thanks for this useful video

  • @ExcelTutorials1
    @ExcelTutorials1 4 роки тому

    Thanks for the awesome video!!!!

  • @datamanagementexecutive1359
    @datamanagementexecutive1359 3 роки тому +1

    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

  • @spacegear9379
    @spacegear9379 Рік тому

    what add on can use in sheets to be able to see the function information like it shows around @2:05

  • @nilson_nieto
    @nilson_nieto 9 місяців тому

    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.

  • @MisterFizz
    @MisterFizz 2 роки тому

    Is it possible to search and filter on text inside NOTES as part of the search criteria?

  • @KhademalUmmah
    @KhademalUmmah 2 роки тому

    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?

  • @BeneuuuuJ
    @BeneuuuuJ 3 роки тому +1

    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 !

  • @bhatmanzoor490
    @bhatmanzoor490 2 роки тому

    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.

  • @simon_quinn
    @simon_quinn 3 роки тому +1

    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.

  • @haraigoshi9133
    @haraigoshi9133 11 місяців тому

    THANK YOU. JFC this saved me some time. /subscribe

  • @dieken310
    @dieken310 3 роки тому +1

    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 =)

  • @michaelluo8893
    @michaelluo8893 2 роки тому

    is there a way to include in your region filter a value that returns all regions?

  • @svetlanas6910
    @svetlanas6910 4 роки тому

    Hi Leila, I would like to register to All Excel Courses. Will I get a certificate at the end? Thank you

    • @LeilaGharani
      @LeilaGharani  4 роки тому

      You will receive an electronic certificate for every course in the bundle you completed.

  • @KuntheaEak
    @KuntheaEak 2 роки тому

    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")?

  • @rjgittuwala
    @rjgittuwala 4 роки тому

    Mam, your video is simple and informative. Thanks. Your beautifulness is increase with time !!! Howzat !!!

  • @webstories9105
    @webstories9105 Рік тому

    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

  • @SONLON
    @SONLON 2 роки тому

    Hello, Great video I went to filter my spreadsheet and now I can not make go back to the original order now the numbered items are not matching up with the numbers. How do I reset the filter back to normal? If that makes sense.

  • @baijuvijayaraghavan3624
    @baijuvijayaraghavan3624 3 роки тому

    Possible to see the results in another tab in the same worksheet?

  • @MarwanAShareef
    @MarwanAShareef 4 роки тому

    Perfect, go ahead boss

  • @The848382
    @The848382 4 роки тому

    Sweet flower 🌷

  • @GauravSrivastava-no7mu
    @GauravSrivastava-no7mu Рік тому

    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?

  • @heya_masr
    @heya_masr 2 місяці тому

    We use Google Forms to survey children entering our nonprofit programs. We have 1000+ entries. The survey for children is by location pre- and post-programming. Can we use filters on the form for the post-survey to filter the names by location so we don't have to search for 1000+ names? Please help! I really appreciate any help you can provide.

  • @DivineLightProductions
    @DivineLightProductions Рік тому +1

    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?

  • @huseyinbakir2017
    @huseyinbakir2017 4 роки тому

    thanks teacher.

  • @ronfromhk
    @ronfromhk 2 роки тому

    Leila, how to make a drop down menu, and box display and dding buttons on a page to display desired results. thnx

  • @mahsekerpolat729
    @mahsekerpolat729 3 роки тому

    Hi Leila! Is there a way to limit the output of this function to the Top 10/ Bottom 10 results?
    I am new to G-sheet :)

    • @kshitijjain1604
      @kshitijjain1604 3 роки тому +1

      Yes, you can use SORTN instead of SORT (as mentioned in the video).
      SORTN returns the first n items in a dataset after performing the sort.

    • @mahsekerpolat729
      @mahsekerpolat729 3 роки тому

      @@kshitijjain1604 thanks, sounds like I by mistake overheard this ! :)

  • @simonhill2668
    @simonhill2668 3 роки тому +3

    As always, thanks for the excellent tutorial. Loved it.... may I ask for a tip please?
    I basically want to be able to filter a range of columns. The usual formula is something like this:
    =Filter(Data!A2:Z,Data!A2:A = Choices!A2, Data!B2:B = Choices!B2)
    Where A2:Z is the range and the filter for column A is A2 and the filter for column B is B2. In other words, the user enters filter choices in A2 and B2. In future, I will extend to many columns A, B, C...
    The issue is A2 or B2 may sometimes be empty meaning no filtering is required for their respective columns. Hence, I probably need to add ‘IF’ into the Filter. But I can’t seem to crack it. Can you propose the formula by any chance?

    • @chocochiligaming1541
      @chocochiligaming1541 2 роки тому

      Up up

    • @ericxsim6877
      @ericxsim6877 2 роки тому

      You don't have to modify your formula. Just make sure the source data has record can match specified condition. Example, Choices!A2 = Apple and Choices!B2 is blank. As long as you have a record match these conditions, Filter can generate results for you.

  • @oyesurat
    @oyesurat 9 місяців тому

    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.

  • @Danna0Y
    @Danna0Y 4 роки тому

    Dear,
    Can i use filter with two sheets?

  • @kuldeepdahiya8264
    @kuldeepdahiya8264 2 роки тому

    Is it possible to put filter on row

  • @BKbk-hl5lo
    @BKbk-hl5lo 3 роки тому

    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.

  • @prem_netam
    @prem_netam 2 роки тому

    Can be use at a time google Excelsheet filter use multiple user

  • @zafkodemis
    @zafkodemis 2 роки тому

    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?

  • @MonikaR2006
    @MonikaR2006 4 роки тому

    I am a HUGE fan of your videos. They have helped me with a lot if complex issues and I am very grateful for that. Did you cover the following yet and I have not found it? Inserting a text box in to Excel and link it with a formul? =VLOOKUP. I tried doing this accross various sheets (invoice - clients) but always receive an error message. Thank you.

    • @LeilaGharani
      @LeilaGharani  4 роки тому

      Am glad to hear that :) You need to write your Vlookup formula in a cell somewhere (you can hide it from view) and then link the text box to the result of the Vlookup. You cannot have a formula inside the textbox.