• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter - More than 2 conditions

chandrashekarb

New Member
Hi,


I would like to know is there any way to put filter for more than two conditions using VBA. I am using Excel 2003.


Regards,


Chandra Shekar B
 
Not using AutoFilter. I'd recommend using Advanced Filter (which can also be used via VBA)


Linky:

http://www.contextures.com/xladvfilter02.html
 
Hi Luke,


Thanks for your reply. I want to filter records(More than 2 criteria) in the same column.


For Ex: In Column B I need to filter on name like Christ, Chandru & Luke.


Regards,


Chandra Shekar B
 
Chandrashekarb


Welcome to the Chandoo.org Forums


You can do that using Advanced Filter

I actually discussed it about 2 days ago at: http://chandoo.org/forums/topic/extracting-multiple-entries

You should be able to understand this by just reading my comments
 
After checking out Hui's suggestion, if for some reason that won't work for you, here's a hybrid formula-filter method:


In some cells somewhere, create a list of the words you want to filter on (I'll assume using col Z)


Near your data, have a helper column with formula:

=ISNUMBER(MATCH(Cell_with_name_in_it,Z:Z,0))


Then you can filter this column on "TRUE"
 
Back
Top