|
![]() |
![]() |
The Criteria Range holds the conditions which control which rows are extracted to the Destination Range. The Criteria Range must contain the same column headings as the Data Range, and must be defined as at least the column names and one row below. Criteria ranges must contain at least two rows. The top row contains the names of the fields in which to search, and the other rows list the conditions that must be met. Criteria may be numbers, strings, or formulas. Criteria in the same column are treated as "or" statements, and criteria in different columns are treated as "and" statements. If the criteria range were f1:f2, all records whose Region field was "West" would be extracted from the database. If the criteria range were f1:f3, all records whose Region field matched either "West" or "South" would be extracted. If the criteria range were f1:g2, all records that matched the criteria of Region being "West" and the Sales field being "high" would be extracted. For criteria containing formulas, the field must be explicitly referred to in the formula. For example, to extract the records for all employees whose ID numbers are greater than 103, the criteria would read =A2>103. The same rules apply for "or" and "and" in rows and columns.
See also |
||
|
||