FILTER can only be used to filter rows or columns at one time. In order to filter both rows and columns, use the return value of one FILTER function as range in another.

We believe in our products and services and the benefits that having clean, clear water will bring to your home and family. We back all our products with superior service and an industry-leading warranty.

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Our Deluxe Water Softener improves your water quality to make everyday tasks easier. From softer skin to more efficient appliances, our Deluxe Water Softener provides excellent performance at an affordable price.

You have a budget – we have a financing option to match it. We offer a wide variety of financing options to help our customers provide the cleanest water possible for their families. Contact your local Water Depot location to learn about our current promotions and finance rates.

condition1 - A column or row containing true or false values corresponding to the first column or row of range, or an array formula evaluating to true or false.

UNIQUE: Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

We provide FREE in-home water tests to customize your water treatment solution to your home’s water chemistry and family’s water demands.

Municipal & Rural applications Removes hardness Reduces Clear Water Iron High-efficiency softening media Auto regeneration based on usage Automatically measures every drop of water for high-efficiency results Electronic demand controls for improved functionality Minimal maintenance costs 7-year warranty

condition2 ... - [ OPTIONAL ] - Additional rows or columns containing boolean values TRUE or FALSE indicating whether the corresponding row or column in range should pass through FILTER. Can also contain array formula expressions which evaluate to such rows or columns. All conditions must be of the same type (row or column). Mixing row conditions and column conditions is not permitted.