Grab the file I used in the video from here 👉 pages.xelplus.com/filter-sheets-file
@PraveenKumar-ms7kc
3 ай бұрын
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
@TylerStanczak
3 жыл бұрын
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
3 жыл бұрын
😂 the KZitem algorithm has some work to do... or maybe they know what Google Sheets users really need 😉
@TylerStanczak
3 жыл бұрын
@@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 :)
@zaralaisradgemonteiro8260
3 жыл бұрын
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!
@Prasadtr
2 жыл бұрын
What if we want ALL region , in Drop down if add "ALL" What is the changes need to do on filter formula ?
@dashcamvids
6 ай бұрын
thankyou so much.. i couldnt explain what i wanted and spent a lot of time searching online until i landed on this!!
@LeilaGharani
6 ай бұрын
Great to hear!
@emailbenbenson
2 жыл бұрын
THANK YOU - Have have watched 10 videos trying to find somebody to show me how to do this!!!!
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
@pastryboy714
Жыл бұрын
The best for my food cost automation calculator! thank you 😍
@eljinet
2 жыл бұрын
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
@virajwaghmare4488
3 жыл бұрын
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.
@LeilaGharani
3 жыл бұрын
Thanks for your feedback Viraj!
@germaincharlie2277
2 жыл бұрын
Really nice video, helped me to solve lots of issues, hats to you Leila
@birasafabrice
Ай бұрын
Excellent tutorial as usual, thank you!
@SurfingBetweenAtoms
12 күн бұрын
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.
@gracemark5995
3 жыл бұрын
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...............😁😁
@LeilaGharani
3 жыл бұрын
Great 👍
@nitu0606
2 ай бұрын
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..
@nilson_nieto
5 ай бұрын
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.
@westernugmedia.1305
3 жыл бұрын
I thank you for your well spoken and understandable language madam. Am from Uganda-Africa
@LeilaGharani
3 жыл бұрын
Glad you like the video Bruno :)
@nssdesigns
2 жыл бұрын
Thanks, you make me look like a hero at work
@systemssde3405
Жыл бұрын
Your Filter formula is useful for me. Thank you.
@nasuhamazlan4862
4 ай бұрын
Hi @LeilaGharani, is there have a way to filter 2 things, like have two drop-down chooses.
@tundeodebunmi6333
8 ай бұрын
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
@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 👍
@sachinkalra6078
2 жыл бұрын
Hey Leila, I was wondering if we can arrange multiple columns in filter function Like sortby function in excel
@hamedalizadeh8782
3 жыл бұрын
I have been looking for this for years! Thank you thank you thank you.
@LeilaGharani
3 жыл бұрын
Glad I could help!
@aaronfist3419
2 жыл бұрын
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.
@MarkPhillipsgms
7 ай бұрын
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?
@DerekBlais
3 жыл бұрын
I really appreciate your many recent Google Sheets videos. I also like the suggestions you make for its improvements. I hope Google is listening.
@LeilaGharani
3 жыл бұрын
Glad you like them Derek!
@greggowaffles
3 жыл бұрын
That was supper helpful and such high quality! Thanks for sharing!!
@LeilaGharani
3 жыл бұрын
Glad it was helpful! Thank you.
@dimitrisblane6368
10 ай бұрын
Hi. Thanks so much you make it look very easy! Can I have an "ALL" drop down filter?
@Bikman
3 жыл бұрын
thank you for your tutorial.
@LeilaGharani
3 жыл бұрын
Welcome 😊
@dieken310
2 жыл бұрын
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 =)
@datamanagementexecutive1359
2 жыл бұрын
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
@Flying_Scorpion
Жыл бұрын
This was very helpful, so glad this is up on youtube.
@LeilaGharani
Жыл бұрын
Glad you enjoyed it!
@MaggieBernard3
3 жыл бұрын
This is really helpful and easy to understand. Thank you!
@ivanurbina2422
Жыл бұрын
Awesome tutorial, thank you.
@leitzagorman9248
2 жыл бұрын
Extremely helpful, thanks!
@KuntheaEak
Жыл бұрын
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")?
@amit4329
3 жыл бұрын
Mam your presentations are always very perfect and well arranged ... 👌👌👌
@LeilaGharani
3 жыл бұрын
So nice of you :)
@MisterFizz
Жыл бұрын
Is it possible to search and filter on text inside NOTES as part of the search criteria?
@AJ-et3vf
Жыл бұрын
Awesome video! Thank you!
@TheSnowfarmer
2 жыл бұрын
You are a fantastic teacher, Leila!
@oyesurat
5 ай бұрын
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.
@bhatmanzoor490
Жыл бұрын
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.
@rajsahu1029
3 жыл бұрын
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.
@LeilaGharani
3 жыл бұрын
Glad you're feeling better.
@Mister1World
Жыл бұрын
Super super useful thanks a lot!
@yazmut
Жыл бұрын
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?
@yasufumithebest
Жыл бұрын
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.
@lpanebr
3 жыл бұрын
I love this function. I don't know in excel, but in sheets you can filter non adjacent columns using the array notation {}. Do it you wanted to return App and Profit only you'd use filter({C6:C,E6:E}, ... ;-)
@LeilaGharani
3 жыл бұрын
Thanks Luciano. Yes - in Excel you can too: kzitem.info/news/bejne/sKSryp-tcnZ-n4o
@davidtmiller56
3 жыл бұрын
Yet another great video. Well done. I watch these for the subtle nuances. Little things that i really didn’t think about.
@patrickschardt7724
3 жыл бұрын
The multiple conditions feature is nice. Wish Excel had that. Great tutorial
@DiaborMagics
9 ай бұрын
I'm getting an error that the row count is mismatched. What am I doing wrong? column B checks column A for if values are 0 or 2 and if neither, then it show false. If it's one of the two, it shows the row number. So I get something like this in column B: FALSE FALSE FALSE 9 FALSE FALSE 20 etc. There are over 10.000 rows and I'm trying to filter in a different column so that all the "FALSE" values are ignored. There are no headers. So in K1, I put the following formula: =FILTER(B:B,FALSE). I probably wrote the formula wrong but I don't see how that would result in it stating it can only find 1 row where it expects over 10.000. The range covers B:B. This gives the same error: =FILTER(B1:B,B1FALSE)
@meghaanil3740
3 жыл бұрын
Great vedios and well explanation.help me a lot for crack my exam and assignments.thanks a lot❤️
@spacegear9379
Жыл бұрын
what add on can use in sheets to be able to see the function information like it shows around @2:05
@SONLON
Жыл бұрын
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.
@scienceenthusiastplaygroun3496
Жыл бұрын
THank you so much! This is a life saver!
@Astral_Ocelot
3 жыл бұрын
oh perfect! this is EXACTLY what i was looking for! thank you!
@BeneuuuuJ
3 жыл бұрын
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 !
@pavithragokhale1424
Жыл бұрын
This is so helpful.. thanks a lot Leila!
@sarfdhillon
4 ай бұрын
Awesome as always
@fazelmovahhedi7536
2 жыл бұрын
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?
@panupong9278
2 жыл бұрын
Thank you, That's really helpful.
@sahilmanocha
3 жыл бұрын
Your videos are very nicely edited, it's cool!
@LeilaGharani
3 жыл бұрын
Thank you very much!
@kunjalchawhan6658
2 жыл бұрын
Amazing Explanation! It's clear now :)
@kctinternet
2 жыл бұрын
Thank you so much for your help
@georginamoron5345
2 жыл бұрын
Your content is more than great! you have been help me so much with all your tutorials :D
@LeilaGharani
2 жыл бұрын
Happy to hear that, Georgina!
@KhademalUmmah
Жыл бұрын
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?
@mohaiminkader6634
3 жыл бұрын
IT was a great video. Please keep bringing more google sheet videos. Thanks
@LeilaGharani
3 жыл бұрын
Thanks, will do!
@prem_netam
2 жыл бұрын
Can be use at a time google Excelsheet filter use multiple user
@ronfromhk
2 жыл бұрын
Leila, how to make a drop down menu, and box display and dding buttons on a page to display desired results. thnx
@DivineLightProductions
Жыл бұрын
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?
@michaelluo8893
Жыл бұрын
is there a way to include in your region filter a value that returns all regions?
@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?
@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.
@nadeemmalik8031
3 жыл бұрын
Brilliant as always. Leila thank you for a wonderful video.
@LeilaGharani
3 жыл бұрын
Glad you enjoyed it!
@chrism9037
3 жыл бұрын
Very helpful Leila!
@LeilaGharani
3 жыл бұрын
Thanks for dropping by Chris.
@AccountingandQuickbooks
3 жыл бұрын
Very nice thank you for share
@LeilaGharani
3 жыл бұрын
Thank you too
@Sal_A
3 жыл бұрын
1) When you added B5:B, that translates the range will start from B5 until the last row of the workbook or the data? Does this effect the performance of workbooks with lots of formulas? 2) There is no screen tip for formulas like Excel in Google Sheet without having to press F1? 3) Can you evaluate formulas in GS like the F9 key in Excel? 4) Does GS have structured tables like Excel? Thank you!!
@LeilaGharani
3 жыл бұрын
Hi Sal - in regard to your questions: 1) To an extent but not like Excel. With Google sheets, the rows are restricted to 1000 rows - unless you need more then it of course expands. But because it's restricted, it's as if your formula goes to 1000 rows. In Excel this will go to the bottom of the workbook which will make files slower. 2) There is, but in my experience it seems if you turn if off once, it remembers and keeps it off unless you turn it back on. 3) Unfortunately not, you have to evaluate on the grid by breaking down the formula 4) No
@Sal_A
3 жыл бұрын
@@LeilaGharani Thank you ma'am!
@Sal_A
3 жыл бұрын
@@LeilaGharani one more thing - how do you know or how do you tell the range B5:B goes to 1000 rows? So if you have 2000 rows of data where does that range reference go to?
@Layarion
Жыл бұрын
great video. do you have a video telling what the difference between google and ms sheets are?
@HusseinKorish
3 жыл бұрын
Thanks Leila ... this is perfect
@LeilaGharani
3 жыл бұрын
Glad you like it!
@willschmitt349
11 ай бұрын
PLEASE HELP!! I have followed your video perfectly and my formula still comes up with a #Value! It says the filter range must be a single row or a single column.
@user-rx3oz7sf5n
7 ай бұрын
My filtered result is further filtered into another sheet. Each time a new row is added to my filtered result, the new sheet will fail to recognize the new filtered result as the row number is shifted down. How can i resolve this. Thank you
@fabiolaverduga
2 жыл бұрын
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?
@simon_quinn
2 жыл бұрын
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.
@LittleLord82
Жыл бұрын
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
@ricos1497
3 жыл бұрын
I actually think I prefer the logical statements in Excel, than the multiple conditions in Sheets, I'm not sure why, perhaps I'm a traditionalist! I really wish they'd both offer the ability to aggregate though. Something like: FILTER(C5:E,B5:B6=H6,SUM(D5:D)>0) *, where filter is more akin to a SQL select and group by statement (although Excel could assume the groupings as implicit). Maybe sheets has something for this. *obviously, that wouldn't be applicable in this example as it is already grouped at app/region level, but app sales by division would need aggregated as a better example. Edit: I've probably got the syntax of the function wrong, we really just want to be able to specify the "Select" columns in the first criteria and the conditions (where clause) in the second criteria. Something like: =FILTER((C,D,SUM(E)),(B5:B6=H6)*(SUM(D5:D)>0))
@LeilaGharani
3 жыл бұрын
Hi Rico, agree -more flexibility in the function would have been great. Google sheets has the query function which can do everything you've listed here (it uses SQL syntax). I'll have to make a few videos on that for KZitem. It would be great if Excel would a get a function like that.
@ricos1497
3 жыл бұрын
@@LeilaGharani Yes, I forgot about that one, you should it on a previous video (I think I even commented on it!). I'll put a suggestion in to the UserVoice people.
@virajwaghmare4488
3 жыл бұрын
Incase while using this function you need to have dynamic columns. In this case for eg: App and Profit. Then the formula should be - =SORT(FILTER({C5:C,E5:E},B5:B=D5:D>0,2,TRUE)
@NathanielStockwell
Жыл бұрын
Excellent explanation, thank you for the help! (:
@mochi5523
2 жыл бұрын
When you had "multiple columns" in your title, I thought you meant the CONDITIONS. Do you have a video on what I'm asking for?
@pedalera2
2 ай бұрын
I could not get the file to pratcie. Is it working?
@OddvinAlmenning
3 жыл бұрын
Greate tutorial Leila!
@BestFriendsForeverTrue
3 жыл бұрын
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.
@user-ko4ji6cu2d
2 жыл бұрын
So i did the forumlar, no errors. I can see the drop down list but no data transfers over
@topelectro560
Жыл бұрын
yeah i need this fucntion but the data from the other link, or use IMPORTRANGE
@zafkodemis
Жыл бұрын
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?
@vida1719
3 жыл бұрын
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
@LeilaGharani
3 жыл бұрын
Hi Vida. Agree - I like that too. It makes it easier to type in the formulas.
@sethumadhavan375
3 жыл бұрын
Leila, As usual its excellent. You are rocking.
@LeilaGharani
3 жыл бұрын
Thank you! 😃
@mohammedrahman7381
3 жыл бұрын
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?
@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
@sagrindentertainment5269
Жыл бұрын
How can I use the filter formula to filter month and year in the same formula?
@genessymendoza4066
3 жыл бұрын
Thank you 🙏 instructive
@rjgittuwala
3 жыл бұрын
Mam, your video is simple and informative. Thanks. Your beautifulness is increase with time !!! Howzat !!!
Пікірлер: 205