filter or format based on criteria in more than one column
 

I want to remove entries in a list based on meeting the criteria in two
different columns. Anyone know how to do it?

filter or format based on criteria in more than one column
 

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?

filter or format based on criteria in more than one column
 

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

filter or format based on criteria in more than one column
 

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.

filter or format based on criteria in more than one column
 

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.