Which column is filtered

You do this by building a filter. If you've ever queried data in a database, this will look familiar to you. Point to either Number Filters or Text Filters in the list. A menu appears that allows you to filter on various conditions. Choose a condition and then select or enter criteria. Click the And button to combine criteria that is, two or more criteria that must both be met , and the Or button to require only one of multiple conditions to be met.

Experiment with filters on text and numeric data by trying the many built-in test conditions, such as Equals , Does Not Equal , Contains , Greater Than , and Less Than. For more information, see Filter data in a range or table. Note Some of these conditions apply only to text, and others apply only to numbers. Create a custom filter that uses multiple criteria. For more information, see Filter by using advanced criteria. Learn how to Filter for unique values or remove duplicate values.

Under Sort On, choose how you would like to sort. Note that Excel can sort by cell or font color in addition to values. University of Michigan Library Research Guides. Ask a Librarian. Explains the basics of common features in Microsoft Excel for PC. Filtering Data In addition to sorting, you may find that adding a filter allows you to better analyze your data.

Sorts the column's entries by Z-A, from top to bottom. Incidents in the incident list screens can be grouped, allowing an alternative filtered report. Grouping incidents enables deep drill down into a problem. For more information, refer to Grouping Incidents on page When this option is selected, a pop-up caption box appears enabling you to filter the column according to specific words or to filter the column to exclude specific words.

In most cases, you can select one of the following options in the Must field:. Contain - Select this option if you want only incidents containing a specific word to appear in the incident list. If an entry in this column contains the word you enter, it appears in the incident list. Entries that do not contain this word do not appear. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 7 months ago. Active 9 years, 7 months ago. Viewed 5k times.

I am using Microsoft Interop to read the data. Improve this question.