Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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.
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help getting first column data based on criteria? Tami Excel Worksheet Functions 5 August 23rd 06 12:17 AM
calculate average in a column based on criteria in another column sharon t Excel Discussion (Misc queries) 2 May 12th 06 07:07 PM
move contents of column C based on criteria related to column A Debra Excel Discussion (Misc queries) 2 December 27th 05 11:25 PM
Filter based on a column of items Pasko1 Excel Discussion (Misc queries) 1 August 23rd 05 12:56 AM
How to add data to a column based on criteria from another Lynn Bales Excel Discussion (Misc queries) 4 July 14th 05 05:11 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"