| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
Hybrid Mode
