<<Convert Excel Spreadsheets to Web Pages \| Trading Software That Operates Within Excel \| Convert Excel, Access & Other Databases \| Merge Excel Files>>

Excel AutoFilters Custom Option

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

Using Custom AutoFilter to filter items in a list by more than one condition

Excel AutoFilter Custom Option

As you know, Excel's AutoFilter allows a user to filter items in a list according to a set criteria one one column at a time. AutoFilter has an option named Custom, which will allow a user to filter items by more than one condition on the same column.

If you select Custom from the AutoFilter drop down list, you will be presented with a dialog box. The dialog box is broken into four parts. Let's say we want to show records for people who have birthdays after 1 January 1965 and before 31 December 1976. To do this, we would make the following selections from the Custom dialog box and click OK:

This will display only people whose birthdays fall between 1 January 1965 and 31 December 1976.

Custom Views

You can save your newly filtered list as a Custom View, so that at any time you can easily return to it, filters already in place. To do this go to View>Custom Views and click the Add button. Give your view a name and make sure you have a tick next to Hidden rows, columns and filter settings. This is a must to retain all the settings. Click OK.

You can then call up your filtered list as a Custom View by going to View>Custom Views, clicking on the name of your view and selecting the Show button.

Go Back To: Excel AutoFilters Start

See Also: Advanced Filters

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft