Excluding null values

  1. Create a new value filter.
  2. In the Filter By field, select Value.
  3. In the Condition field, select Equals.
  4. In the Value field, enter null.
    Only blank cells are returned. They are indicated by #NA!