7 Ways to Use Advance Filter

Download Now or  Read it online

Advance Filter is the most powerful feature of Excel. The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. It allows the person to quickly remove duplicates, extract records that meet certain criteria. It works great when we use wildcards, within 2 date criteria.

Filtering is a simple, however, amazing & powerful way to analyze data. Advance filter are quite easy to use. Here's how you can use Excel's advanced filtering capabilities.

In this article we have created tutorials of advance filter, in which you can learn how to use formula and functions for filter and how to use advance filter.  Below you can find different ways of Advance filter.



Introduction to Advance Filter
Using “And”, “Or” and Multiple Criteria
How to Filter Unique Records?
How to Use Wildcards?
Extract records after specific date criteria
Extract items between 2 Date’s criteria
How to extract data with specific text?
How to extract data to another worksheet using VBA?


  1. Thanks for the user manual; a great read and very helpful. For what it's worth I just thought the title, spelling and grammar within should be proof read. The command is Advanced Filter (Advance with a "d" at the end) Thanks again.

  2. M Ekramul Hassan

    Thank you very much to provide such a filtering processing system and this is helpful for me and my colleagues.

    With best regards.


  3. Functions like vlookup doesn't work if you open two instances of Excel. Is there anyone who knows you to open two Excel files on different monitors and still have functions like vlookup working?

  4. Try this... This will allow a single instance of Excel to display two (or more) files simultaneously. With good size screens you could comfortably open 4 files in a square pattern.
    open ONE instance of Excel
    use the restore button (button next to the "X" to close a window) to allow sizing of the Excel window,
    stretch to fit both monitors,
    open both of your spreadsheet files,
    use THEIR restore button(s) to size to whatever orientation you wish.
    This will allow you to orient the two (or more) files either vertically or horizontally.

  5. Lloyd Russell

    In my experience it depends on the version of Excel, if you are using version 2010 or earlier you need to have an additional version of Excel running and then open/drag the file to there. If you have a later version it is simply a case of dragging the open window over to the other screen (worth upgrading for this in my opinion)

  6. Open 2 instances of Excel from the Start Menu then move one to the new window.
    Trying to open 2 sheets in one instance will not work.

  7. Once I have a first Excel file open, I simply open a new instance of Excel from the Start Menu. It seems to work with my current (default?) settings in Excel 2010.

  8. I work with two monitors to view different files.

    I would like to have two different excel files open on two monitors. What setting must be changed to get that. I had tried some other options in earlier versions of excel but I am using excel 2007.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.