Excel.Tips.Net ExcelTips (Menu Interface)

Advanced Filter

There may be a time when the basic capabilities of Excel's AutoFilter tool are not enough to accomplish the task at hand. Fortunately, you can take filtering to another level if you just instruct Excel to filter a certain way. Use the following articles to learn what you can do in Excel with advanced filtering.

Tips, Tricks, and Answers

The following articles are available for the 'Advanced Filter' topic. Click the article's title (shown in bold) to see the associated article.

Advanced Filtering
Many people know how to use AutoFilter, but there are times when you need some more filtering muscle. Here's how you can use Excel's advanced filtering capabilities to see only the parts of your data that you need to see.

Copying Comments when Filtering
The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.

Copying the Results of Filtering
Filtering is a great asset when you need to get a handle on a subset of your data. Excel even makes it easy to copy the filtered data to another location, as described here.

Extracting Targeted Records from a List
When working with large amounts of data, you may have a need to extract just the information that meets the criteria you specify. Excel provides the built-in tools that make this task easy.

Performing Calculations while Filtering
The advanced filtering capabilities of Excel allow you to easily perform comparisons and calculations while doing the filtering. Setting up the filter is easy, as described in this tip.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.