Results 1 to 4 of 4

Advanced Filtering

Threaded View

jn_mohit Advanced Filtering 03-14-2008, 01:09 AM
Portuga You can use the auto filter... 03-14-2008, 01:38 AM
jn_mohit Thanks for your help but I am... 03-14-2008, 01:46 AM
Portuga The VBA code I wrote above... 03-14-2008, 02:06 AM
  1. #1
    Registered User
    Join Date
    07-08-2005
    Posts
    11

    Advanced Filtering

    I have a data which I would like to filter, I decided to go for Advanced Filter.

    A simple example, in the given sheet I have data in 6 columns and I would like to have the filter as
    Channel = 1 or 2
    Mode = diff
    Temp = 25 or 85
    Reference = 6 or 7
    Vdd = 2.25

    (Please note that I can have many conditions here and hence Autofilter can not be used) If I have to have an autofilter for this it should look like the yellow box on the "FilterConditions" Sheet.

    My questions is how do I write a VBA program to do this, I would want to find all combinations and put them in proper order by choosing 1 from each column at a time.

    I am also not sure how many conditions would be available (I can decide the max though, let say 10 if someone needs it)

    Any help would be highly appreciated.

    Thanks
    Mohit
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1