Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to remove entries in a list based on meeting the criteria in two
different columns. Anyone know how to do it? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Mark your header row, DataFilterAutofilter Use the dropdowns on each of the 2 columns to select the rows meeting the criteria you want. When you have the rows you want to remove as the only visible rows on the screen, select the entire rows by clicking on the row numbers, Right clickDelete row DataFilterShow All -- Regards Roger Govier "tabbicat" wrote in message ... I want to remove entries in a list based on meeting the criteria in two different columns. Anyone know how to do it? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you for the reply. The lists I am working with are over 2500 rows long
though, with more extraneous rows than pertinent ones. I have to start out with them to get all the relevant info on the items I want to use. I want to be able to perform the same actions on multiple lists quickly too. I am learning that the AutoFilter command is more versatile than I had first thought. And searching this forum has turned up links to some good macros. Now, I am having problems getting the AdvancedFilter to detect my criteria. When I run it, it copies over the entire list. I have selected "Copy to new location" so that I could see it is actually doing something. I had to read the About Filtering help page to figure out what to put in the Criteria Range (I thought). I don't get error messages anymore, but it results in an identical copy of the original list. I am about to start searching for an answer to that problem or how to write a macro for the "right-click, Delete" solution. Thanks again "Roger Govier" wrote: Hi Mark your header row, DataFilterAutofilter Use the dropdowns on each of the 2 columns to select the rows meeting the criteria you want. When you have the rows you want to remove as the only visible rows on the screen, select the entire rows by clicking on the row numbers, Right clickDelete row DataFilterShow All -- Regards Roger Govier |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Well I've found a way that works for me at
http://www.contextures.com/xlautofilter03.html#Copy Debra's site is awesome! And this forum is great. It seems like you can do just about anything with an Excel spreadsheet, if you can only figure out how. Thanks to everyone who takes the time to help others put all the pieces together. To that end, my solution was to use the autofilter. Then use the macro I found at Contextures to copy the results into a new sheet. The new list is exactly how I wanted it. BTW the problem with my Advanced Filter was that, following the examples in the help pages, I had put my criteria range above my list. After looking around Contextures, I moved my criteria range to the side, and it worked just fine. Thanks again to everyone. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Had I realised at the outset that you wanted to extract data to another sheet, I would have suggested Advanced Filter and would have directed you to Debra Dalgleish's site at Contextures. She has excellent instruction on all manner of things, including Filtering - as you have found. Thank you for posting back and letting us know how you got on, and well done for your resourcefulness in finding the solution that suited you. -- Regards Roger Govier "tabbicat" wrote in message ... Well I've found a way that works for me at http://www.contextures.com/xlautofilter03.html#Copy Debra's site is awesome! And this forum is great. It seems like you can do just about anything with an Excel spreadsheet, if you can only figure out how. Thanks to everyone who takes the time to help others put all the pieces together. To that end, my solution was to use the autofilter. Then use the macro I found at Contextures to copy the results into a new sheet. The new list is exactly how I wanted it. BTW the problem with my Advanced Filter was that, following the examples in the help pages, I had put my criteria range above my list. After looking around Contextures, I moved my criteria range to the side, and it worked just fine. Thanks again to everyone. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help getting first column data based on criteria? | Excel Worksheet Functions | |||
calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Filter based on a column of items | Excel Discussion (Misc queries) | |||
How to add data to a column based on criteria from another | Excel Discussion (Misc queries) |