| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Remove Rows that match a criteria
I have data that I am filtering based on State. I want to remove all the rows
that have 'TX' in State Column. I used data filtering and from the dropdown, selected 'TX'. When I get the filtered data, I select the rows and 'delete'. The problem is, it deletes every other row as well. I migrated from exel 2003 to 2007 and see a 'bug' where 2007 can not remove the selected rows only... Quite frustrating. Is there any way to achieve this without writing any macro? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count rows that match 3 sets of criteria? | Excel Worksheet Functions | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
| How to get number of rows which match criteria | Excel Worksheet Functions | |||
| Copy Rows if Lookup Criteria Match | Excel Discussion (Misc queries) | |||
Threaded Mode
