+ Reply to Thread
Results 1 to 10 of 10

Need to add criteria #3 to the autofilter... how do I?

  1. 05-20-2012, 07:54 PM #1
    slicksilver79
    slicksilver79 is offline
    Registered User
    Join Date
    03-05-2004
    Posts
    31

    Need to add criteria #3 to the autofilter... how do I?

    The title and the attachment explains it all. What's the easy way to do this without programming and all? I dont know anything about VB.

    Thanks
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 05-20-2012, 08:27 PM #2
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Need to add criteria #3 to the autofilter... how do I?

    it would be more helpful if you uploaded a sample workbook. not every1 (myself included) can view .png files, plus, it will save us having to possibly retype all your data in to help you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 05-20-2012, 08:31 PM #3
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Need to add criteria #3 to the autofilter... how do I?

    @ raj-sample files makes it easier to look at instead of pictures.

    you could also look at advanced filterinstead of custom filter.to add more criteria.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  4. 05-20-2012, 09:28 PM #4
    slicksilver79
    slicksilver79 is offline
    Registered User
    Join Date
    03-05-2004
    Posts
    31

    Re: Need to add criteria #3 to the autofilter... how do I?

    Sorry about that guys. Excel file attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-20-2012, 09:32 PM #5
    slicksilver79
    slicksilver79 is offline
    Registered User
    Join Date
    03-05-2004
    Posts
    31

    Re: Need to add criteria #3 to the autofilter... how do I?

    I want the ID numbers of quilt, razai and comforters. This list is really small but otherwise the real list has 30000 entries and I'd like to know how I can find the ID values of 3 entries in one shot. Thanks all.
    Reply With QuoteRegister To Reply
  6. 05-20-2012, 09:52 PM #6
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need to add criteria #3 to the autofilter... how do I?

    How about this...

    You are going to have to do an advanced filter manually or you can opt for this simple macro setup
    Attached Files Attached Files
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  7. 05-20-2012, 10:18 PM #7
    slicksilver79
    slicksilver79 is offline
    Registered User
    Join Date
    03-05-2004
    Posts
    31

    Re: Need to add criteria #3 to the autofilter... how do I?

    Quote Originally Posted by jeffreybrown View Post
    How about this...

    You are going to have to do an advanced filter manually or you can opt for this simple macro setup
    Jeff it works exactly like how I want it. Question is how do I do it myself?
    Reply With QuoteRegister To Reply
  8. 05-21-2012, 09:05 AM #8
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need to add criteria #3 to the autofilter... how do I?

    Here is a great tutorial on Advanced Filter.

    With this file there are two named ranges

    Criteria =items!$F$1:INDEX(items!$F:$F,MATCH(REPT("z",255),items!$F:$F))
    FilterParam =items!$B$1:INDEX(items!$B:$B,MATCH(REPT("z",255),items!$B:$B))

    Column F has the criteria and Column B is where you want the filter applied.

    Add a couple of shapes and then apply two macros to these shapes.

    Press Alt + F11 to see the two macros that are currently in the file.
    Reply With QuoteRegister To Reply
  9. 05-21-2012, 11:56 PM #9
    slicksilver79
    slicksilver79 is offline
    Registered User
    Join Date
    03-05-2004
    Posts
    31

    Re: Need to add criteria #3 to the autofilter... how do I?

    Thank you jeffreybrown!
    Reply With QuoteRegister To Reply
  10. 05-22-2012, 07:48 AM #10
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need to add criteria #3 to the autofilter... how do I?

    You're welcome…glad it worked for you and thanks for the feedback...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1