O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Advanced AutoFilter Functions

In Hour 21, you learn about filtering data with Excel's nifty AutoFilter feature. This session takes that discussion one step further and talks about using advanced AutoFilter functions, such as extracting filtered data, and using the Top 10 AutoFilter and Custom AutoFilter options.

After you filter your records to display specific data in your database, you can extract that data by copying it to another worksheet or workbook. It's simple to do—just use the Copy and Paste tools to place the filtered data somewhere else.

As for fancy AutoFilter functions, you have Custom AutoFilter that lets you set up comparison criteria, as well as create AND or OR criteria. For example, you can search for all the employee ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required