Excluding/Row Filtering using Rule-based Row Filter

[hyehye28]

Hello!

In Column A, I would like to filter the rows that only contain Y and N. In Column B, only contain Y.

How to do it using Rule-based Row Filter? Thank you!

[stelfrich]

Hi @hyehye28,

you can find additional information on Advanced Row Filtering in our E-Learning Course.

You can use the following rules to achieve your filtering:

NOT (($A$ MATCHES "Y") OR ($A$ MATCHES "N")) => FALSE
$B$ MATCHES "Y" => TRUE

There’s also a lot of other ways to re-write those rules.

Best,
Stefan

[hyehye28]

Thank you for your kind help!