799
Finding and Filtering Data in a List
➔ For more details on working with named ranges, see “Using Named Ranges in Formulas,” p. 728.
Begin entering criteria in the row just below the column labels. You can enter text, numbers,
dates, or logical values using comparison operators such as > and <. To find values that are
greater than or equal to a specific value, use the >= operator. For example, >=1000 finds all
values greater than or equal to 1000 in the specified column; in a text column, <C finds all
entries that begin with A or B.
You can enter values in more than one column and in more than one row. When you do,
Excel interprets your input as follows: ...