Thanks, Leila! I’m a long-time Excel user who writes VBA and is now climbing the Power Query (M), Power Pivot (DAX), & Power BI learning curves. But, I never learned or used Advanced Filters. So easy ... with your expert explanation, that is! 👍
I thought I already knew a lot about Excel... but after watching your videos, I feel I have only scratched the surface! Learning from you is giving me renewed energy! THANK YOU LEILA!!!
I very rarely comment on youtube but I have to say that Leila is my absolute favorite reference when it comes to Microsoft suite. It's like you read my mind and always have the perfect answer to my exact question. I can't count the amount of time I shared your videos or articles to help a coworker on some of their questions, and you instantly become their favorite too. Thank you for spreading the knowledge with your extremely high quality content, you really are making an impact.
I'm studying for a big history exam and have an Excel with all the centuries, dynasties and people in it 😅 I've been painstakingly filtering for each unique word when I study by using the search function! Thanks to you, I now know how to quickly filter and find the most important information.
Lot and Lots of thanks to my Excel teacher, who is posting Excel videos, which is very simple to understand. Very Lucid. I am praying the almighty to bestow her good health, as she is doing a great job indeed, for the Excel lovers/users/addicts. Waiting eagerly very much for the VBA Series with your authentic style.
Thank you very much Gopala for the very kind words and for your support. I'm working on the VBA course, and I should be ready to start posting some VBA videos here in two weeks time....
Advanced filter and unique records only is maybe the best Excel tip I ever received. I already spend ours on google to figure out how to this. Thanks a lot!
Till for today I starting watching your videos and found something unique. Most of the videos on youtube tell us all the things which we have already know. But in your videos, I learn something extra about excel. Thumbs up and Goodluck for your hard work.
I rarely post comment, but felt I have to; spent > 10 min on microsoft support page and still couldn't figure it out, over here, < 1 min everything is clear! thank you!!
Really i can't get bored while iam watching your videos. Nowadays business is low due to covid 19. I have decided to watch everyday 2 videos for you starting from excel introduction. The reason is there is always alot of information where wr can miss them. You are a great teacher dear i wish you the best because you always astonish us with your nice videos.
Your videos are the best. I have been writing VBA code over twenty years. I can record a marco while I use your instructions for a specific excel task, then modify the recorded macro. Thanks
Your videos are very clear, and specific, I'd wish Microsoft could explain it this way not the convoluted way they always use. I feel like a 8 year old when I watch your videos, because of the clean and nature simple way you have to explain, ideas are simple, minds are complicated, sometimes if one can't explain it in a way an 8 year old understand it , is because it is still not fully understood at all. Microsoft should learn something here.,( same as the videos from Mr Randy Austin) , Love it , Kudos Leila , and greetings from New York!!.
Only your videos help me in funding solutions to my day to day excel related problems.. Thank you so much. My first ever response on any videos on you tube
Really nice i watch 100 of videos on Advance filter but no one told me that typing in below is or condition and typing another column is and condition which has solved my problem Many thanks dear
Thank you sooo much for this easy to understand explanation of advanced filter. Looking back now it is absurd how much trouble I was having; your instruction got me set straight.
how can we use advance filter for a condition where I want channel=store OR product = pants blue. means or condition for different columns. Or in other language I want records where either channel is store or product is pants blue ( using advance filter only)
Thank you, Leila! A great not so used feature beautifully explained. What I would like to add, if I may, although you did mention it has the value of 'OR', is that in the advanced filter range there's no need to fill in every cell, for example if we wanted to filter by Store with Sales above 200 and also ANYTHING that has Sales = 200 we would type that as: Channel_____Sales Value store________>200 ________100 PS. And it works with Dates too :).
You're very welcome & thank you for your input. Absolutely right. OR conditions with anything can be mixed in as well which allow for more flexibility.
Great video. Good pace of teaching as well. I discovered that the basic key is that the criteria given in same row mean AND condition. OR condition cannot be inserted in the same row. Thanks a lot Leila for clearing this.
Wonderful and insightful video Leila. Please if you don't mind ne asking, what criteria does excel decide what value is unique. I initially thought it meant the only value that wasn't repeated but that a not the case here
Great tips Leila, I've been trying to find a solution to this problem for 3 - 4 years. I plan to use the 'copy unique list' with my list of 'mail opens' for my weekly email bulletins over an extended period (weeks, months etc.) where my emails are sent out once a week. That way I'll know who opened my email over the past 5 weeks/months whether someone opened them each week/month or only opened one of my emails.
Thanks Leila, list of 'email opens' over the past 12 weeks totalled almost 700 which, when the 'copy unique list' function was used, was reduced to 167 individual users. Awesome.👍
Hi , Thank you for all your informative videos. I have a question how to make the "filter" automatically updated ? If i have a sheet that's brings values from another sheet and I want only specific value to be appeared but I don't want to apply the filter on the second sheet every time I added a new value to the first sheet.
This's very helpful!! I like the way you explain, now thinking of using this with VBA that creating a report in 5 mins without spending time to go through all the tabs...
Thank you Zahid for your comment! I would love to be able to get more weekly videos out here. For now once a week works - in the future I might be able to do more :)
Hey Leila, Hope you are doing well, first of all thank you for your each vedio wherein you are elaborating nice way and it is powerful ! I am fan of you ! I like the way you are covering all most essential areas , keep it up and keep sharing ! Thanks a lot !
Is it possible to automate this further? I need the data in another sheet. Is it possiblete create a macro that retrievesthe data from the othersheet? 🙏
Thank you, Leila. I've been following your videos in recent days you are a Genius. I love your tutorials and tips. :) It saves a lot of time every day. I have a question: How to use the advanced filter for the cell color?
Thanks so much! One issue that I encounter is that I cannot use Advanced Filter unless I start from the data tab. In the video you are able to start from the location where you want the filtered data to show...any explanation?
Grab the file I used in the video from here 👉 pages.xelplus.com/filter-advanced-file
Thanks, Leila! I’m a long-time Excel user who writes VBA and is now climbing the Power Query (M), Power Pivot (DAX), & Power BI learning curves. But, I never learned or used Advanced Filters. So easy ... with your expert explanation, that is! 👍
Wow Jim, that's quite a climb. I'm glad I could help support it a little bit :)
I thought I already knew a lot about Excel... but after watching your videos, I feel I have only scratched the surface! Learning from you is giving me renewed energy!
THANK YOU LEILA!!!
edwin enriquez
Same situation here. Ms Leila is very creative and talented. I appreciate her a lot.
I very rarely comment on youtube but I have to say that Leila is my absolute favorite reference when it comes to Microsoft suite. It's like you read my mind and always have the perfect answer to my exact question. I can't count the amount of time I shared your videos or articles to help a coworker on some of their questions, and you instantly become their favorite too. Thank you for spreading the knowledge with your extremely high quality content, you really are making an impact.
Wow, thank you very much Véronique for the kind feedback. I really appreciate it!
Working on a tough project, this video saved me days of work. Leila is the freaking GOAT don't @ me
Thanks!
You explain it better than Microsoft's own "experts". Thank you.
I'm studying for a big history exam and have an Excel with all the centuries, dynasties and people in it 😅 I've been painstakingly filtering for each unique word when I study by using the search function! Thanks to you, I now know how to quickly filter and find the most important information.
Lot and Lots of thanks to my Excel teacher, who is posting Excel videos, which is very simple to understand. Very Lucid. I am praying the almighty to bestow her good health, as she is doing a great job indeed, for the Excel lovers/users/addicts. Waiting eagerly very much for the VBA Series with your authentic style.
Thank you very much Gopala for the very kind words and for your support. I'm working on the VBA course, and I should be ready to start posting some VBA videos here in two weeks time....
I've been an Excel user from the beginning, but this video was so helpful and Leila's voice is so soothing to listen to.
I'm glad you like it John.
Advanced filter and unique records only is maybe the best Excel tip I ever received. I already spend ours on google to figure out how to this. Thanks a lot!
Glad it was helpful!
Till for today I starting watching your videos and found something unique. Most of the videos on youtube tell us all the things which we have already know. But in your videos, I learn something extra about excel. Thumbs up and Goodluck for your hard work.
I'm glad to hear that :) Thanks for the thumbs up!
I rarely post comment, but felt I have to; spent > 10 min on microsoft support page and still couldn't figure it out, over here, < 1 min everything is clear! thank you!!
Happy it was helpful, Kevin!
Really i can't get bored while iam watching your videos. Nowadays business is low due to covid 19. I have decided to watch everyday 2 videos for you starting from excel introduction. The reason is there is always alot of information where wr can miss them. You are a great teacher dear i wish you the best because you always astonish us with your nice videos.
I love the way, you have been teaching us effective methods. Thank you a million times.
My pleasure. Glad you like the video.
Your videos are the best. I have been writing VBA code over twenty years. I can record a marco while I use your instructions for a specific excel task, then modify the recorded macro. Thanks
Finding of unique records does save lot of time...you have various solutions with advanced usage for one requirement, simply superb
It's good to have some of these solutions in the toolbox. Glad you find the tutorials useful.
Thanks for the Advanced Fun, after the summit : )
Thanks Mike. It was great to meet you at the summit!
Your movies always teach me not only basic technique, but also advanced one. Thanks!
You're very welcome. I'm glad you like the tutorials.
Dudes have not realized yet, how POWERFUL this function is and how MAGNIFICENT your teaching 💪🧚♀️💯
Thanks for the kind feedback Said :)
Your videos are very clear, and specific, I'd wish Microsoft could explain it this way not the convoluted way they always use.
I feel like a 8 year old when I watch your videos, because of the clean and nature simple way you have to explain, ideas are simple, minds are complicated, sometimes if one can't explain it in a way an 8 year old understand it , is because it is still not fully understood at all.
Microsoft should learn something here.,( same as the videos from Mr Randy Austin) , Love it , Kudos Leila , and greetings from New York!!.
Thank you very much for the kind feedback Edward! I'm happy the videos come across like that.
I watched a few videos on this subject and yours was the only one that made any sense! This will save me so much time. Thanks so much!
Only your videos help me in funding solutions to my day to day excel related problems.. Thank you so much. My first ever response on any videos on you tube
Really nice i watch 100 of videos on Advance filter but no one told me that typing in below is or condition and typing another column is and condition which has solved my problem Many thanks dear
Happy to help :)
Thank you sooo much for this easy to understand explanation of advanced filter. Looking back now it is absurd how much trouble I was having; your instruction got me set straight.
I learned these advanced formulas which made my daily tasks in excel much easier.Thank you Liela
Happy to hear that!
Thank you for taking the time to film this!
You are so welcome!
Mam, Always wants to say you
thanks you so much for sharing all these excel videos.
You are the greatest teacher.
Thanks a lot!
@@LeilaGharani 🤗🙏❤️
Love your videos....you have gotten me out of a jam so many times. Thanks for the content....keep it coming!
Will do 😊
Thank you so much Leila. All your excel tutorials are very helpful and understandable. I love it. I love your channel.
Miss Leila, I watch your videos frequently as a refresher course
Thank you! I'm glad to hear that Imran :)
You are one of the best excel teacher!
You are one of kind the greatest woman in the world thank you so much Ms. Leila.
Thank you so much Ismail for the very very kind comment. I really appreciate your support of this channel.
I normally use the remove duplicates for unique values .. thanks to you... now i can use advance filter to get the unique records ... thanks again
Amazing... teaching excel in the simplest and the best way possible... :)
Thanks a lot!
literally the best explanation on youtube
Appreciate that, James!
The way you teach is very effective, thank you very much.
Great refresher, I still tend to enter criteria as a string ; = "=whatever" and have found that it can still help when dealing with wildcards.
how can we use advance filter for a condition where I want channel=store OR product = pants blue. means or condition for different columns. Or in other language I want records where either channel is store or product is pants blue ( using advance filter only)
Learnt something new today after using Advanced Filters for many years. Thank you.
I'm glad to hear that :)
Thank you, Leila! A great not so used feature beautifully explained.
What I would like to add, if I may, although you did mention it has the value of 'OR', is that in the advanced filter range there's no need to fill in every cell, for example if we wanted to filter by Store with Sales above 200 and also ANYTHING that has Sales = 200 we would type that as:
Channel_____Sales Value
store________>200
________100
PS. And it works with Dates too :).
You're very welcome & thank you for your input. Absolutely right. OR conditions with anything can be mixed in as well which allow for more flexibility.
I find you the best in explaining excel facts...
Great video. Good pace of teaching as well. I discovered that the basic key is that the criteria given in same row mean AND condition. OR condition cannot be inserted in the same row. Thanks a lot Leila for clearing this.
Excellent! Thank you Leila, its easy and clear. I wished to know it before but Im happy that now I know it.
So helpful! thank you :) - from Missouri, USA
Good work ,Leila !
Wonderful and insightful video Leila.
Please if you don't mind ne asking, what criteria does excel decide what value is unique. I initially thought it meant the only value that wasn't repeated but that a not the case here
Thank you so much! I finally understand how the advanced filter works! I have to learn and understand it since I have exam tomorrow! Thank you!
Great! and good luck!
@@LeilaGharani Thank you so much!!!
I am searching for unique records for years but Miss Leila you solved my problems in just one video 7 minutes only
I'm SO happy to hear that! These things can be really frustrating! Thanks for the feedback.
Hi leila,.. I am watching your all Excel video very interesting and advanced level
Very useful as usual!
You are excellent at explaining this material! Thank you!
Glad it was helpful!
Advanced Filter is a great feature that few know about or use. Thanks Leila for the reminder!
Very true! It took me a while to find out about it too :)
Content were the one I sought. Amazing
Great tips Leila, I've been trying to find a solution to this problem for 3 - 4 years. I plan to use the 'copy unique list' with my list of 'mail opens' for my weekly email bulletins over an extended period (weeks, months etc.) where my emails are sent out once a week. That way I'll know who opened my email over the past 5 weeks/months whether someone opened them each week/month or only opened one of my emails.
That's great! I'm happy to hear that. Yes, the "copy unique list" would come in handy here :)
Thanks Leila, list of 'email opens' over the past 12 weeks totalled almost 700 which, when the 'copy unique list' function was used, was reduced to 167 individual users. Awesome.👍
Thank you so much Leila. Very useful.
Very Helpfull!
Follow up question. Is there a symbol to use to show you any product that DOES NOT CONTAIN the word pants i.e., instead of *pants*
Wonderful lecture in advance filter! Thanks Leila!
You're welcome K.Clark :)
Hi leila i loved this but can we also tell sort a big data table by partcilar words 1 after another in a row
Hi ,
Thank you for all your informative videos.
I have a question
how to make the "filter" automatically updated ?
If i have a sheet that's brings values from another sheet
and I want only specific value to be appeared
but I don't want to apply the filter on the second sheet every time I added a new value to the first sheet.
Thank you!
So if I want Channels Store & Website I have to put those horizontally?
Thanks for sharing im learn something every videos u make. Very ingotmative direct to the point to the topic. Thans. Keep itt up.
10,000 thanks for this video. Happy happy joy joy!
Thank you too Thomas!
I like this channel.........everything you teach that actually in simply way or understandable ❤️😊🤟🏻
Happy to hear that!
You are awesome Leila. Thanks a million
Leila you are super refined in your explanations :D
Thank you! 😃
Very useful tricks for MIS , Thank You Leila!
You're very welcome Sanjay.
This's very helpful!! I like the way you explain, now thinking of using this with VBA that creating a report in 5 mins without spending time to go through all the tabs...
I'm very glad to hear that. Sounds like a good plan.
i learned too much from this video ma'am you are a best teacher
your explanation is very splendid and varsatile
Thanks for the ultimate solution. You are brilliant..
That was awesome!! Thank you so much!! Please keep these coming!! 👍👍
You're very welcome! Thank you for your comment & support.
Dear Leila!
It was very interesting. I enjoyed . From teaching your video.
THANK YOU LEILA!!!
My pleasure! Glad you like the video.
You're a great teacher!
Thank you! Glad you like the teaching :)
I already watched advanced filter but nobody taught what is and and or or how to interpret them.. thanks
As always.. thank you very much.. 👍👍👍🌹🌹
Many many thanks Leila! Please increase the frequency of uploading videos as we are waiting. Thank you so much once again!
Thank you Zahid for your comment! I would love to be able to get more weekly videos out here. For now once a week works - in the future I might be able to do more :)
Very helpful ma'am 😊
I often use advanced filter instead of vlookup when I want the original table. I learned some new ways to use it from this video.
Glad you were able to pick up something new Jonathan.
This really helped. Thanks! New Subscriber.
Hey Leila,
Hope you are doing well, first of all thank you for your each vedio wherein you are elaborating nice way and it is powerful ! I am fan of you !
I like the way you are covering all most essential areas , keep it up and keep sharing !
Thanks a lot !
Thank you Dashrath for your kind words and your support!
the video is really useful for me. Thank you much
Nice, It is really useful for our daily reports
❤very good video. It's just what I needed to know.
This is really cool! Never knew Excel had a dynamic filter like this. Thanks!
Glad you liked it!
Is it possible to automate this further? I need the data in another sheet. Is it possiblete create a macro that retrievesthe data from the othersheet? 🙏
Thank you, Leila. I've been following your videos in recent days you are a Genius. I love your tutorials and tips. :) It saves a lot of time every day. I have a question: How to use the advanced filter for the cell color?
Really great presentation. Thank you very much.
Good Clear Helpful Videos!
My collegues will like this lecture too. Thx. Leila from HUN
Wow such a great Video Leila! How (which shortcut?) did you use to do the higlithing trick of the columns in 06:35? Thank you!
Thank you. I used control & shift & down arrow key.
Thank you very much!!@@LeilaGharani
Hi! Can we filter multiple columns which has date?
Superb Lecture !! Very useful!! Very intuitive
Happy to hear that!
Hi ...please suggest for filter a large Excel list which comprises numerics & texts as well. How could I filter only texts or numbers in one go ?
2:38 the conditions are not working in the basics tab....
same problem here. I thought I was the only one facing this.
Leila, Can you please share a video about how to apply filter on tables in same sheet
Thanks so much! One issue that I encounter is that I cannot use Advanced Filter unless I start from the data tab. In the video you are able to start from the location where you want the filtered data to show...any explanation?
Thank you so much for making these videos, Leila! I have learned so much from them
Thanks for easy example.
I really appreciate this. Please how do we filter date? E.g..01/012017 before or after. Thank you