Not with just formulas....but you can do it with VBA, or with one of the
features in the ASAP Utilities Add-in, which are available free at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"CHARI" wrote:

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.