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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Remove Rows that match a criteria
I have not yet installed my copy of 2007 yet but it serves you right for trying to remove TX. -- Don Guillett SalesAid Software "Mahesh" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Remove Rows that match a criteria
Hi
You are quite correct. The behaviour is not the same as with AutofilterSelectDelete. However, if you click on a cell within your data and choose InsertTable then use the dropdown on the filter created on your state header to select TX. Now, mark the rows, right click and the options will be Delete Rows (as opposed to Delete) and your rows with TX will disappear (sorry Don<bg). Click on the Filter and choose Show All and the remainder of the data will be there. -- Regards Roger Govier "Mahesh" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Remove Rows that match a criteria
Roger,
Thanks so much for the information. It saved me a lot of time. - Mahesh "Roger Govier" wrote: Hi You are quite correct. The behaviour is not the same as with AutofilterSelectDelete. However, if you click on a cell within your data and choose InsertTable then use the dropdown on the filter created on your state header to select TX. Now, mark the rows, right click and the options will be Delete Rows (as opposed to Delete) and your rows with TX will disappear (sorry Don<bg). Click on the Filter and choose Show All and the remainder of the data will be there. -- Regards Roger Govier "Mahesh" wrote in message ... 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 |
Reply |
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) |