Microsoft KB Archive/63802

{| = Excel: Finding All Records That Do Not Have Blank Fields =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q63802

SUMMARY
To find all records in a Microsoft Excel database that are not blank in a particular field, enter &quot;<>&quot; (without quotation marks) in the criteria range.

For example, if the database is as follows

Field 1 | Field 2  | Field 3 a       | y        | z   b        |          | y   c        | s        | d       | e        | f set the criteria as follows: Field 1 | Field 2  | Field 3 | <>      | The extracted records are: Field 1 | Field 2  | Field 3 a       | y        | z   c        | s        | d       | e        | f

MORE INFORMATION
To find all records that do not contain blank fields, enter &quot;<>&quot; (without quotation marks) in the criteria range under all field names, as follows:

Field 1 | Field 2  | Field 3  | ... <>      | <>       | <>       | <> For more information about Microsoft Excel databases, see pages 347-387 in the &quot;Microsoft Excel User's Guide&quot; version 3.0 manual. If you are using Excel 2.20, see pages 148-179 in the &quot;Microsoft Excel Reference&quot; version 2.2 manual.
 * }