I'm using two sheets, one with the main values and reference datas.
The second sheet is for price calculation.
=Filter to get the values from sheet one where
Sheet1!E2:E <> 1.
How can I get the row from Sheet2 deleted when the value is no longer inside the Filter Condition?