Hi People!

I'm looking for solution to delete rows that contain a cell having a certain value.

A1: Store X, B1: Opened
A2: Store Y, B2: Closed
A3: Store Z, B3: Opened

I'd like to delete the rows that have the cell value: Closed