Delete Row ABOVE

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

How would I delete rows if

If b2="Void"
Then I would like for it to delete Row 2 and Row 1?
 
Hi,

In column C, use the foll. formula in cell C1
=if(or(B2="Void",B1="Void"),"delete",1). Copy this all the way down. Now
select the column and press Ctrl+G > Special > Formulas > Text. This will
select all the cells which have delete. Now you may delete these rows

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top