Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter and delete
I have received a large spreadsheet of information I am trying to clean up.
Based on what is in several different columns a row may or may not need to be deleted. I have added a column and written a formula (copied to each row) that says either "Delete" or is left blank. I can then filter the list by the delete column and get rid of them. The problem I have is once you unfilter there are blank rows which have to be sorted to remove. Once completed this is all going to be done with a macro so I was looking for a cleaner way of doing this. Any help will be appreciated. Thanks. Jordan |
#2
|
|||
|
|||
I figured out that I need to use Advance Filter and have a new question
posted reguarding criteria. Please ignore this post. Didnt know how to delete it. Thanks. "Jordan" wrote: I have received a large spreadsheet of information I am trying to clean up. Based on what is in several different columns a row may or may not need to be deleted. I have added a column and written a formula (copied to each row) that says either "Delete" or is left blank. I can then filter the list by the delete column and get rid of them. The problem I have is once you unfilter there are blank rows which have to be sorted to remove. Once completed this is all going to be done with a macro so I was looking for a cleaner way of doing this. Any help will be appreciated. Thanks. Jordan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
I want to delete duplicate rows of similar info and use the lates. | Excel Discussion (Misc queries) | |||
How do I delete filtered lines in Excel 2000? | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |