Using the Advanced Filter for complex OR criteria


show more Using the Advanced Filter for complex OR criteria provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Using the Advanced Filter for complex OR criteria

Excel's filtering feature covers lots of ground and it works in most situations for most filtering. But there is another tool called an Advanced Filter. Let's take a look at why we might need this kind of a filter. This is a little involved, a little more cumbersome setting up, and it does involve something called a criteria range. What I am about to do is not at all obvious, so now I'll have to explain a little bit ahead of time and a little bit later. When you see a criteria range, it is usually in most examples that you might see in an Excel book on Advanced Filtering above the data.

So what I am about to do here with this data is to highlight the first six rows and then right-click and Insert, and I am going to be copying the title row here, simply by dragging across these titles and I am going to drag this upward with the Ctrl key held down, put these into row 1. You might see in some examples a criteria range located to the right of the data. It could be there. It could b...

Using the Advanced Filter for complex OR criteria
Video duration: 4m 30s 1h 32m Appropriate for all

Viewers:

Using the Advanced Filter for complex OR criteria provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...