Deleting rows based on IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I delete a row based on an IF statement?

For example, if cell h2=C and if cell k2 = zero, then delete that row.

Thank you.
 
I would apply Data|Filter|Autofilter to the whole range.

Then I'd filter on column H to show "C"
Then I'd filter on column K to show 0

Then delete those visible rows

Then Data|Filter|show all
to see everything left.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Rows based on condition 2
How to find first row where condition is true? 12
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
delete row on based on cell value 1
Delete ROW based on Cell Contents 4
Making the AND function look at only part of a cell entry 2
Number of rows over 30 days after creation 1
Linked Cells – If Statement 1

Back
Top