Delete Rows
 

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

Delete Rows
 

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 wrote:

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

Delete Rows
 

Thanks

"Dave Peterson" wrote in message
...
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 wrote:

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