How to Use Advanced Filters in Excel

In addition to the built-in AutoFilters in Excel, you can create Advanced Filters that allow you to extract unique records or calculate criteria based on external data.

I do not use Advanced Filters as much as I did in the past because Excel 2007 greatly improved the built-in AutoFilters. However, you will pick up at least two good tips from this lesson - including how to extract Unique Records and copy them to a new worksheet.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to see all of my resources and explore the many products and services that I offer.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Excel
• Data Filters
• Advanced Filters
• Criteria Range
• Unique Records
• Extract Data Records
• software
• office
• technology
• programs
• management
• Computer Software
• Training
• Software Tutorial
• Business
• Educational

[TheDarkENJ]

Thanks man, this helped heaps, but I have a question, how do I use an advanced filter for a between function?

[DannyRocksExcels]

@TheDarkENJ

I am getting an error trying to post my response.here. I will try to send you my response via Message.

Danny Rocks

[Karin16121968]

I tried and it works!

[DannyRocksExcels]

@Karin16121968

I am very pleased that I could help you with this!

Danny Rocks

The Company Rocks

[Karin16121968]

Thanks for your tutorial it is very helpful. I Have one question how I am able to filter by date for example 04.07.2011 and not by month if I have these data in one column, in my case I have only the possibility with the drop down to filter by month even thought I have insert the date. Sorry for my English I hope you can understand what I mean!

[DannyRocksExcels]

@Karin16121968

Here is what you do: Use the drop-down filter for the date field. You will see all of the unique date values listed here. Simply, de-select ALL of the dates and SELECT the single (Excel 2003) or multiple individual dates (Excel 2007 and Excel 2010) that you wish to see in your Filtered Report.

Danny Rocks

The Company Rocks

[fromRomaniaWithLove1]

but if I need to extract the table list of invoices issued to customers in New York and New Jersey in the year of 2009 and field results must contain only the entries Number invoice, Invoice date and Value?

[fromRomaniaWithLove1]

but

[fromRomaniaWithLove1]

but if I want to extract a list of invoices issued to customers in New York and New Jersey in the year of 2009 without naming the field 'Customer' but simply filling criteria....notice that the field results must contain only entries Invoice Number, Invoice Date and Value....please help