Deleting specific Rows

[surveyorinva]

I have four columns of data (A thru D)
Column E returns a True or false if it finds A1 anywhere in column D
Column F returns a True or false if it finds D1 anywhere in column A
Column G returns 1 if E1=False, F1=True
returns 2 if E1=True, F1=False
returns 3 if E1=False, F1=False
What is the way to tell Excel that if it searchs Column G and for every row whos value is 3, clear the data for that row from columns A thru D?

 

[Bob Phillips]

Add a filter (Data>Autofilter) on column G, pick 3, and then delete the
visib le rows. Remove the filter, and the other rows are still there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have four columns of data (A thru D)
Column E returns a True or false if it finds A1 anywhere in column D
Column F returns a True or false if it finds D1 anywhere in column A
Column G returns 1 if E1=False, F1=True
returns 2 if E1=True, F1=False
returns 3 if E1=False, F1=False
What is the way to tell Excel that if it searchs Column G and for every

row whos value is 3, clear the data for that row from columns A thru D?