jeudi 8 novembre 2018

how to create an if statement on google sheets based on two rows of data

Click to view data I need to create an IF statement for the following:

If the column 'Device Type' contains the value ' PIR' delete row, If the row above 'PIR' has alarm type ' reset' and has the same time as the PIR row, delete this row too,

Is this possible to do?

Aucun commentaire:

Enregistrer un commentaire