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.

The Deringer 20 (DC) 2″ Double Check Backflow Preventer is a reliable and efficient solution designed to protect potable water supplies from contamination caused by backflow. Engineered with precision and built to meet stringent industry standards, this backflow preventer ensures the safety and purity of water in various applications.

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.

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.

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.

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.