Tổng Hợp

Advanced Excel Filter (And, Or, Between conditions for criteria range)




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://thefortatsandyhook.net

Xem thêm bài viết khác: https://thefortatsandyhook.net/tong-hop/

Tổng Hợp
[Tiếng Anh lớp 4] – Giải chi tiết đề IOE 4 – vòng 1 – cô Nguyễn Như Quỳnh
Tổng Hợp
Bài 7: Chi tiết các tình huống sao chép của lệnh COPY trong AutoCAD bạn phải biết để vẽ nhanh
Tổng Hợp
DDTank Mobile – Sự Trở Lại Của Huyền Thoại Game Bắn Súng Tọa Độ Phiên Bản Toàn Cầu
  • THANKS A LOT FOR PROVIDING LOTS OF IMPORTANT TIPS REGARDING FILTER. I WANTS TO EXPERT IN DATA SORTING AND FILTERING DATA OF VARIOUS TYPES PLEASE SUGGEST ME WHAT SHOULD I REFER AND FOR WHICH COURSES I SHOULD APPLY ON UDEMY SITE MY E MAIL ADDRESSES IS Mrdongare@gmail.com REALLY THANKS FOR PROVIDING VALUABLES INFORMATION.


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


  • Say I have Table 1 and Table 2 side by side ( sharing rows ).
    How to filter Table 1, such that Table 2 remains unchanged, so rows don't disappear?
    Thanks


  • Awesome just what I was looking for !!!!


  • literally the best explanation on youtube


  • Hi Leila,
    Please help ..
    If in an excel sheet (within a range, anywhere), 2 Week Off days are marked in between 2 Absent Days, how to replace "WO" by "A"?
    This A WO WO A should be like this A A A A……..


  • AND, OR, Between conditions are not working when we try to "Copy to another location". Please try & do a video in it/provide me a solution


  • 👍


  • 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