Page 623 - Excel 2013 All-in-One For Dummies

Keep in mind that after filtering the data list in this manner, you can then copy remaining records that make up the desired subset of the data list to a new area in the same worksheet or to a new sheet in the workbook. You can then sort the data (by adding AutoFilter buttons with the Filter command button on the Data tab), chart the data (see Book V, Chapter 1), analyze the data (see “Using the Database Functions” later in this chapter), or summa- rize the data in a pivot table (covered in Book VII, Chapter 2).
Using the Text Filters options
The AutoFilter drop-down menu for a field that contains only text or a com- bination of text, date, and numeric entries contains a Text Filters option that when you click or highlight displays its submenu containing the following options:
✦ Equals:OpenstheCustomAutoFilterdialogboxwiththeEqualsoperator selected in the first condition.
✦ Does Not Equal: Opens the Custom AutoFilter dialog box with the Does Not Equal operator selected in the first condition.
✦ Begins With: Opens the Custom AutoFilter dialog box with the Begins With operator selected in the first condition.
✦ Ends With: Opens the Custom AutoFilter dialog box with the Ends With operator selected in the first condition.
✦ Contains: Opens the Custom AutoFilter dialog box with the Contains operator selected in the first condition.
✦ Does Not Contain: Opens the Custom AutoFilter dialog box with the Does Not Contain operator selected in the first condition.
✦ Custom Filter: Opens the Custom AutoFilter dialog box where you can select your own criteria for applying more complex AND or OR conditions.
Using the Date Filters options
The AutoFilter drop-down menu for a field that contains only date entries contains a Date Filters option that when you click or highlight displays its submenu containing the following options:
✦ Equals:OpenstheCustomAutoFilterdialogboxwiththeEqualsoperator selected in the first condition.
✦ Is Before: Opens the Custom AutoFilter dialog box with the Is Before operator selected in the first condition.
✦ IsAfter:OpenstheCustomAutoFilterdialogboxwiththeIsAfteroperator selected in the first condition.
Filtering Data 605
Book VI Chapter 2
Filtering and Querying a Data List