I'm using two sheets, one with the main values and reference datas.
The second sheet is for price calculation.
I use =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?