Use the Advanced Filter for Complex Multiple-Field Criteria in Excel


show more Using the Advanced Filter for complex multiple-field 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 multiple-field criteria

When you're trying to use filtering on multiple columns involving multiple criteria, the standard filter just doesn't work some of the time. We need to use an advanced filter. Suppose in the data here comprised of about 700 rows, we need to see people from a certain department who are full time and we also want to see people from another department who are half- time. And you can imagine some other combinations like that. What we need to do is set up a criteria range, so let's highlight the first six rows, put this above the data, insert, and simply copy the top row here, holding down the Control key drag this upward.

Let's just pick some departments here, for example ADC. Rather than typing this, I am just going to copy this up here. We would like to see out of the ADC department, the full time people. There are two of them. Once again to save myself some typing here, something with the Ctrl key I am going to drag this here. We are also interested in getting and seeing peo...

Using the Advanced Filter for complex multiple-field criteria
Video duration: 5m 37s 1h 32m Appropriate for all

Viewers:

Using the Advanced Filter for complex multiple-field 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 ...