Is there a way to delete an entire row if specific columns are blank?

[mcalice]

I am trying to create a list of only "Qualified" sales leads with their current activity.


I have a sheet with a list of each salesperson's Contacts that includes their qualifying components indicated with a 'yes' in any or all of the component columns, G, H, I, and/or J.


Then a sheet with a list of all of the salesperson's Activities by Contact.


I've combined these two into one list that gives me the qualified leads indicted in columns G, H, I, and/or J.


My question is, is there a way to remove the rows with the unqualified contacts, indicated by all columns G, H, I and J being blank.


I hope my question makes sense, and thanks in advance for any assistance!

 

[SteveT]

Simplest way You can create a helper column for all the criteria = Keep or Delete.


Then highlight the helper column.


Find Delete but click on Find All. Shift Click and Highlight all the items in the list that pops up below in the find all dialog box.


Click Close.


Then press Alt+E then D and a delete dialog box will come up.


choose delete row.

 

[Luke M]

This may be what Steve said, but reworded...

In helper column:

=COUNTA(G2:J2)=0

Filter column on True, delete all those rows.

 

[mcalice]

Thanks for the quick response Steve, I'll give that a try!

 

[mcalice]

perfect, thanks Luke! That helps too!