DELETE ROWS BY USING A IF/THEN QUERY
 

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.

DELETE ROWS BY USING A IF/THEN QUERY
 

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.

DELETE ROWS BY USING A IF/THEN QUERY
 

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.