Check the Excel Essentials Course:
How does Advanced Filter work in Excel? In this quick tutorial I show you many examples that explain:
1. How to setup advanced filter
2. How to use the criteria range in advanced filter
3. How to use wildcards
4. How to setup your criteria to filter for OR / AND conditions
5. How to filter between two dates or two numbers with advanced filter
6. How to get a list of unique values
🡻 Download the workbook here 🡻
★★ Links to related videos: ★★
Excel Filter Trick:
Excel Filter Basics:
★ My Online Excel Courses ★
Courses ►
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend:
Get Office 365:
Microsoft Surface:
GEAR
Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:
Microphone:
Lights:
More resources on my Amazon page:
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!
#MsExcel
Nguồn: https://aancom88.com/
Xem thêm bài viết khác: https://aancom88.com/tong-hop/
👍
how do I sort dates from largest to smallest within advanced filters
How we will do it if we want to avoid certain column e.g here we dont want to see date column in the filtered data?
Is there any alternative to new Filter function of Excel 365, cause I have Excel 2019 only
Very useful tool explained in great way…thanks @Laila
learning advanced filters from your video made life so easier when working with SAP-reports. Can you explain how to use filter when ,say, One column say Tender ID has one row filled but adjacent column providing, say, RFQ nos. corresponding to that tender ID exist over multiple rows ..Thats a problem I am facing..Hope my question is not unclear ??
Im not seeing a single forumla….
My days of suffering are gone
Thanks Leila
How to write it as a formula instead stead of using advanced filter?
Great video. Thanks!!
I learnt for the first time
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. So nicely explained learned something new. Thanks
how to get total in end of column?
If I wanna Filter "Store" from Channel column and "Pants Blue" from Product column and I want all the cells to be visible that has "Store" and "Pants Blue" _It's ok if there is "Shirt White" or "Pants Black" against store or vice versa
How can I do that?
(P.S. Thank you so much all of your videos are so helpful)
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 great presentation. Thank you very much.
How can I apply the and criteria in a pivot table?
i expected date filter, i.e bw date 🙁
very useful video,thank u.
Can u elaborate how to compile multiple data for different date are compiled in one file
10,000 thanks for this video. Happy happy joy joy!
Nice ma'am …
Thank you so much for this lecture. Really helps my job to process raw data to a more organized and presentable data. Thank you!
good
hello Leila, i did the same steps that u r showing but my advanced filter is not showing any results.may be there is a important step that u r not stessing /showing/elaborating in your video.in my criteria box i am not getting the wording advanced that u seem to be getting??why is that?please help. dr prasad india