In the list of text values, select or clear one or more text values to filter by.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.
The list of text values can be up to 10,000. If the list is large, clear (Select All) at the top.
Create criteria
1. Point to Text Filters and then click one of the comparison operator (=Equal to, > Greater than,<>=Greater than or equal to, <= Less than or equal to, and <> Not equal to.)commands, or click Custom Filter. For example, to filter by text that begins with a specific characters, select Begins With, or to filter by text that has specific characters anywhere in the text, select Contains.
2. In the Custom AutoFilter dialog box, in the box on the right, enter text or select the text value from the list. For example, to filter by text that begins with the letter "J", enter J, or to filter by text that has "bell" anywhere in the text, enter bell.
No comments:
Post a Comment