Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)

Рет қаралды 698,110

6 жыл бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Dive deep into the world of Excel's Advanced Filter options in this comprehensive tutorial. Learn how to gain full control over your data filtering with practical and detailed instructions, exploring everything from basic filtering to complex criteria settings.
⬇️ Download the workbook here 👉 pages.xelplus.com/filter-adva...
✨ Key Highlights:
▪️ Setting Up Advanced Filter: Step-by-step guide on how to use Excel's Advanced Filter feature for precise data analysis.
▪️ Using Criteria Range: Discover how to filter data using specific criteria in separate cells.
▪️ And/Or Conditions and Wildcards: Learn to apply complex filtering logic, including the use of wildcards and combining And/Or conditions.
▪️ Extracting Unique Records: Find out how to extract unique data entries for streamlined reporting.
▪️ Practical Examples: See real-life scenarios showcasing the power and versatility of Advanced Filter in Excel.
★★ Links to related videos: ★★
Excel Filter Trick: • SURPRISING Advanced Fi...
Excel Filter Basics: • Excel Filter Basics (f...
➡️ 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!
#excel

Пікірлер: 565

@LeilaGharani 4 ай бұрын

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

@jimfitch 5 жыл бұрын

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! 👍

@LeilaGharani 5 жыл бұрын

Wow Jim, that's quite a climb. I'm glad I could help support it a little bit :)

@pizzasammy 2 жыл бұрын

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.

@SquatFull 5 жыл бұрын

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

@edwinenriquez5041 6 жыл бұрын

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

@abufun1718 6 жыл бұрын

edwin enriquez Same situation here. Ms Leila is very creative and talented. I appreciate her a lot.

@abduljabbarkhan9107 5 жыл бұрын

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.

@j_iselle 4 жыл бұрын

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!

@atiqahhumaira8527 2 жыл бұрын

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!

@LeilaGharani 2 жыл бұрын

Great! and good luck!

@atiqahhumaira8527 2 жыл бұрын

@@LeilaGharani Thank you so much!!!

@uvaraj6328 3 жыл бұрын

You are going with very step by step so that very helpful for us and easy for learning also

@TheKylek55 Жыл бұрын

Working on a tough project, this video saved me days of work. Leila is the freaking GOAT don't @ me

@MehmetAliMD 4 жыл бұрын

I love the way, you have been teaching us effective methods. Thank you a million times.

@LeilaGharani 4 жыл бұрын

My pleasure. Glad you like the video.

@ramen10lass78 2 жыл бұрын

Thank you so much Leila. All your excel tutorials are very helpful and understandable. I love it. I love your channel.

@faluzo1978 Жыл бұрын

My collegues will like this lecture too. Thx. Leila from HUN

@javedahmed8343 4 ай бұрын

Content were the one I sought. Amazing

@dklndr5199 3 жыл бұрын

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!

@LeilaGharani 3 жыл бұрын

Glad it was helpful!

@YoussefTsun Жыл бұрын

Your last tip was a mind blowing one

@excaliburgroup3402 4 жыл бұрын

You explain it better than Microsoft's own "experts". Thank you.

@douglasbrown5329 5 жыл бұрын

You always do a fantastic job explaining. Thank you....this was a very informative video!

@veroniquemorin2950 4 жыл бұрын

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.

@LeilaGharani 4 жыл бұрын

Wow, thank you very much Véronique for the kind feedback. I really appreciate it!

@tarosuji4061 4 жыл бұрын

Your movies always teach me not only basic technique, but also advanced one. Thanks!

@LeilaGharani 4 жыл бұрын

You're very welcome. I'm glad you like the tutorials.

@magxsnow 5 жыл бұрын

Great explanation, clear and understandable, love your lectures.Please carry on.

@imranmushtaq7445 5 жыл бұрын

Miss Leila Gharani, very informative and really helps me in accounts as an support software and even I told my colleagues to use your videos on youtube.

@firmaevents9594 3 жыл бұрын

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.

@1gopalakrishnarao 6 жыл бұрын

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.

@LeilaGharani 6 жыл бұрын

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

@dineshaharshani6114 2 жыл бұрын

Thank You. Very good explanation. Helpful

@williamarthur4801 2 жыл бұрын

Great refresher, I still tend to enter criteria as a string ; = "=whatever" and have found that it can still help when dealing with wildcards.

@faisalrehman5798 3 жыл бұрын

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.

@LeilaGharani 3 жыл бұрын

I'm glad to hear that :) Thanks for the thumbs up!

@jubileelifeinsurance5991 4 жыл бұрын

i learned too much from this video ma'am you are a best teacher

@0722568703 2 жыл бұрын

advance filter ! well explained ,thank you !!.

@thomasmccants4350 4 жыл бұрын

10,000 thanks for this video. Happy happy joy joy!

@LeilaGharani 4 жыл бұрын

Thank you too Thomas!

@CarlosEspinoza-me9oi 2 жыл бұрын

Excellent! Thank you Leila, its easy and clear. I wished to know it before but Im happy that now I know it.

@saids.4307 4 жыл бұрын

Dudes have not realized yet, how POWERFUL this function is and how MAGNIFICENT your teaching 💪🧚‍♀️💯

@LeilaGharani 4 жыл бұрын

Thanks for the kind feedback Said :)

@NRAJ1966 Жыл бұрын

your explanation is very splendid and varsatile

@johnhecht5129 4 жыл бұрын

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.

@LeilaGharani 4 жыл бұрын

I'm glad you like it John.

@almonddonut1818 6 жыл бұрын

Thank you so much for making these videos, Leila! I have learned so much from them

@EricaDyson 5 жыл бұрын

Thanks so much. You're an excellent presenter. Keep on publishing more please!

@pankajsoni-qw8cw 4 жыл бұрын

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

@mobr. 5 жыл бұрын

Thank you, I learned something new: advanced filter!

@underamoon 5 жыл бұрын

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.

@LeilaGharani 5 жыл бұрын

Glad you were able to pick up something new Jonathan.

@JyotiRanjan2cology 5 жыл бұрын

Thank you for sharing this video Leila. It helped me a lot in my work. I was trying to make a dynamic filter using Autofilter in macro, but it didn't worked well. Could you please prepare a video for "dynamic filter".

@venkatiyer7459 4 жыл бұрын

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

@braveheartmurali Жыл бұрын

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?

@SimohmedRaiss 3 жыл бұрын

Thank you so much Leila. Very useful.

@cameronlarson4046 5 жыл бұрын

You are an unbelievably great teacher, I learn so much from you, omg

@alextorres10 3 жыл бұрын

The way you teach is very effective, thank you very much.

@uvaraj6328 3 жыл бұрын

Hi leila,.. I am watching your all Excel video very interesting and advanced level

@AdiCristea 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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.

@sachinrv1 6 жыл бұрын

Hi Leila, I always looking forward to watching your videos. Wonderful, informative and very very well explained. By the way one can also use data validation list for ease of using and or between conditions in this advance filter; so that the user need not frequently touch the data else it will be prone to changes.

@LeilaGharani 6 жыл бұрын

That's a great idea actually! I like that. Thanks for your input.

@azizniazi9159 5 жыл бұрын

you are really one of the greatest teachers.

@MySpreadsheetLab 6 жыл бұрын

Advanced Filter is a great feature that few know about or use. Thanks Leila for the reminder!

@LeilaGharani 6 жыл бұрын

Very true! It took me a while to find out about it too :)

@MazUKQ8 4 жыл бұрын

A very well-presented and well-explained video... Thank you

@shashikkantlohar1163 2 жыл бұрын

Thanks for the ultimate solution. You are brilliant..

@muhammadsameer883 4 жыл бұрын

You are awesome Leila. Thanks a million

@ryanmarshall4741 3 жыл бұрын

So helpful! thank you :) - from Missouri, USA

@MrTkraju1957 2 жыл бұрын

I learned these advanced formulas which made my daily tasks in excel much easier.Thank you Liela

@LeilaGharani 2 жыл бұрын

Happy to hear that!

@kevinjing9114 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

Happy it was helpful, Kevin!

@sasavienne 5 жыл бұрын

Thank you Leila. You already know that you are simply amazing. 🌟 🌟 🌟 🌟

@BUREAUTOM 4 жыл бұрын

Really great presentation. Thank you very much.

@keishrich 6 жыл бұрын

Wonderful lecture in advance filter! Thanks Leila!

@LeilaGharani 6 жыл бұрын

You're welcome K.Clark :)

@alexrosen8762 6 жыл бұрын

Extremely useful tutorial. Thanks Leila!

@LeilaGharani 6 жыл бұрын

Thanks Alex. I'm happy to hear that!

@shironmania 5 жыл бұрын

Finding of unique records does save lot of time...you have various solutions with advanced usage for one requirement, simply superb

@LeilaGharani 5 жыл бұрын

It's good to have some of these solutions in the toolbox. Glad you find the tutorials useful.

@vineetkumar2717 3 жыл бұрын

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

@LeilaGharani 3 жыл бұрын

Happy to help :)

@wellyba 5 жыл бұрын

Thanks Leila that was simple but very informative

@lalamalelang5670 2 жыл бұрын

Thanks for sharing im learn something every videos u make. Very ingotmative direct to the point to the topic. Thans. Keep itt up.

@chumkidey6227 3 күн бұрын

Very helpful ma'am 😊

@SanjayKumar-yx6gc 6 жыл бұрын

Very useful tricks for MIS , Thank You Leila!

@LeilaGharani 6 жыл бұрын

You're very welcome Sanjay.

@user-bv4uq5ob5z 4 жыл бұрын

Thanks for easy example.

@paulmartineau3850 10 ай бұрын

Thank you, I have had questions about filters and you have answered them .

@ismailismaili0071 6 жыл бұрын

You are one of kind the greatest woman in the world thank you so much Ms. Leila.

@LeilaGharani 6 жыл бұрын

Thank you so much Ismail for the very very kind comment. I really appreciate your support of this channel.

@chrissaz6977 3 жыл бұрын

You are one of the best excel teacher!

@yimingma5977 2 жыл бұрын

Hi Leila, thank you for the nice lecture. Question: Would a slicer be an alternative way of quick filtering and which method would you recommend in real working scenarios?

@sultanmohiuddin7119 2 жыл бұрын

I find you the best in explaining excel facts...

@excelisfun 6 жыл бұрын

Thanks for the Advanced Fun, after the summit : )

@LeilaGharani 6 жыл бұрын

Thanks Mike. It was great to meet you at the summit!

@SuchinthaJinadasa 5 жыл бұрын

Learnt something new today after using Advanced Filters for many years. Thank you.

@LeilaGharani 5 жыл бұрын

I'm glad to hear that :)

@Sevenoria 3 жыл бұрын

This is really helpful and powerful. Thank you

@boyy1000 4 жыл бұрын

Very informative, thank you very much. I have learnt a new thing in filters today

@rakeshsoni7306 4 жыл бұрын

It's Awsome. Thanks to keep updating us with such an wonderful tricks. Kudos for you👍👍👍

@dashrathpanchal8393 6 жыл бұрын

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 !

@LeilaGharani 6 жыл бұрын

Thank you Dashrath for your kind words and your support!

@AnbarasuAnnamalai 4 жыл бұрын

Nice, It is really useful for our daily reports

@nikhilchowdhary8919 3 жыл бұрын

Leila you are super refined in your explanations :D

@LeilaGharani 3 жыл бұрын

Thank you! 😃

@TonyMackre 5 жыл бұрын

Thank you, this helped me do my homework.

@ctwhaley 2 жыл бұрын

Love your videos....you have gotten me out of a jam so many times. Thanks for the content....keep it coming!

@LeilaGharani 2 жыл бұрын

Will do 😊

@Anadus-Health-Lifestyle 2 жыл бұрын

This really helped. Thanks! New Subscriber.

@esmailmansori5053 4 жыл бұрын

Dear Leila! It was very interesting. I enjoyed . From teaching your video. THANK YOU LEILA!!!

@LeilaGharani 4 жыл бұрын

My pleasure! Glad you like the video.

@staypositive4358 3 жыл бұрын

This is really cool! Never knew Excel had a dynamic filter like this. Thanks!

@LeilaGharani 3 жыл бұрын

Glad you liked it!

@sourabhkalaskar 3 жыл бұрын

I like this channel.........everything you teach that actually in simply way or understandable ❤️😊🤟🏻

@LeilaGharani 3 жыл бұрын

Happy to hear that!

@tomada36 3 жыл бұрын

You are excellent at explaining this material! Thank you!

@LeilaGharani 3 жыл бұрын

Glad it was helpful!

@imranmushtaq7445 5 жыл бұрын

Miss Leila, I watch your videos frequently as a refresher course

@LeilaGharani 5 жыл бұрын

Thank you! I'm glad to hear that Imran :)

@Clara-mz6ev 4 жыл бұрын

Thank you for taking the time to film this!

@LeilaGharani 4 жыл бұрын

You are so welcome!

@ranjunasarangafernando8812 4 жыл бұрын

Thanks a lot great knowledge. Wish you the Best for sharing great knowledge like this..!

@chrisczz 5 жыл бұрын

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

@LeilaGharani 5 жыл бұрын

I'm very glad to hear that. Sounds like a good plan.

@keksisha 7 ай бұрын

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

@mohammedal-mudhafar4602 6 жыл бұрын

Excellent, Very useful for big data

@ZAHIDHUSSAIN-ri5kg 6 жыл бұрын

Many many thanks Leila! Please increase the frequency of uploading videos as we are waiting. Thank you so much once again!

@LeilaGharani 6 жыл бұрын

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

@kuldeep.3012 3 жыл бұрын

Mam, Always wants to say you thanks you so much for sharing all these excel videos. You are the greatest teacher.

@LeilaGharani 3 жыл бұрын

Thanks a lot!

@kuldeep.3012 3 жыл бұрын

@@LeilaGharani 🤗🙏❤️

@semperdiscendum7439 6 жыл бұрын

That was awesome!! Thank you so much!! Please keep these coming!! 👍👍

@LeilaGharani 6 жыл бұрын

You're very welcome! Thank you for your comment & support.

@lathikapreethi9276 4 жыл бұрын

Very useful as usual!

@egvNY 4 жыл бұрын

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

@LeilaGharani 4 жыл бұрын

Thank you very much for the kind feedback Edward! I'm happy the videos come across like that.