Delete Rows

[Doug Van]

Hello,

I have a spreadsheet that imports a text file into the appropriate columns
and gets rid of all the junk.

I don't need someone the info that is imported, probably about 40 different
criteria.

What is the quickest way to delete these rows, do a lookup and then delete
or just enter a line of code for each criteria?

Thanks
Doug

 

[Dave Peterson]

Apply Data|Filter|Autofilter, filter for each value, and delete the visible
rows?

or...

Can you build a table of the bad text on another worksheet.

Then use a helper cell:

=isnumber(match(a1,sheet2!a:a,0))

drag down...

sort by that column and delete the rows that have a TRUE in them.

I'd bet the second way was quicker.

 

[Doug Van]

Thanks

Apply Data|Filter|Autofilter, filter for each value, and delete the visible
rows?

or...

Can you build a table of the bad text on another worksheet.

Then use a helper cell:

=isnumber(match(a1,sheet2!a:a,0))

drag down...

sort by that column and delete the rows that have a TRUE in them.

I'd bet the second way was quicker.