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.
ADVANCE FILTER INDEX: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?