No, you cannot do that with any formula
You'll need some VBA macro code.

HTH
--
AP

"CHARI" a écrit dans le message de news:
...
Is it possible to actually delete a row by using a if,then query? I have
data in a spreadsheet and if there is a particular value in one of the
cells
I would like it to delete the row of data.