Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows meeting certain criteria in a particular column
I am trying to delete the entire row that meets cetain criteria.
The first criteria is a blank cell in column B The second criteria is if the cell in column B contains "tot" or a prompt to enter the criteria. Any help is very much appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows meeting certain criteria in a particular column
You may use "Auto-Filter' or 'Advanced-Filter'.
After filtering you can copy/paste the remaining [visible] records to another [lower] range/location and delete the original source records. Micky "tsraj" wrote: I am trying to delete the entire row that meets cetain criteria. The first criteria is a blank cell in column B The second criteria is if the cell in column B contains "tot" or a prompt to enter the criteria. Any help is very much appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting several rows with given criteria | Excel Discussion (Misc queries) | |||
Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
Deleting rows by specified criteria for duplicates | Excel Discussion (Misc queries) | |||
Display rows meeting criteria on another sheet & summarize them | Excel Discussion (Misc queries) | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions |