Microsoft KB Archive/58100: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - ">" to ">") |
||
Line 18: | Line 18: | ||
----------------------------------- | ----------------------------------- | ||
1 | Salary | | Hire_Date | | 1 | Salary | | Hire_Date | | ||
2 | | 2 | >25000 | |>01/01/1985| | ||
3 | | | | | 3 | | | | | ||
</pre> | </pre> |
Latest revision as of 10:19, 21 July 2020
Criteria Range Must Be Contiguous in ExcelLast reviewed: November 2, 1994 |
SUMMARYA criteria range must be a contiguous area at least 1 column wide and 2 rows high. There may be blank columns or rows in a criteria range. Consider the following example: A B C ----------------------------------- 1 | Salary | | Hire_Date | 2 | >25000 | |>01/01/1985| 3 | | | | Assuming that Salary and Hire_Date are field names in a database, the ranges A1:C3, A1:B2, and A1:A3 are all valid criteria ranges even though column B and row 3 are blank. Selecting A1:A2 and C1:C2 and trying to set criteria on this range will result in the error "Can't do that to a multiple selection." |
KBCategory: kbusage Last reviewed: November 2, 1994 |