Multiple Criteria Dynamic Filter Temple

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Multiple Criteria Dynamic Filter Temple

  1. #1
    New Member
    Join Date
    Jul 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple Criteria Dynamic Filter Temple

     
    Hi,

    I have watched a few a videos and read some on this subject. Unfortunately, none seems to do what I would like unless limited to 1 field search .

    Does anyone have an “out of the box” template that will allow me to:

    1. Dump large amount of data into Sheet 1. Headers in Row 1.
    2. Sheet 2 would have all the headers in Sheet 1 that will allow filtering on one or multiple fields. These would also be in Row 1
    3. All data that is a match or partial match would appear Sheet 2 starting on Row 2.
    4. Would have a master clear button.

    Rules:

    1. Partial filtering by field is allowed. IE: Yellow would be picked up by just typing Yel (along with anything else that contains Yel)
    2. Would also allow for a second or third search within the same filter. IE: Yel Ba 15 (would return Yellow Ball 15OZ)
    3. Does not need to be case sensitive.
    4. Would allow for simple mathematical formula. IE: = , > or < in fields that are numeric.
    5. All is returned as you are typing.

    If not, how difficult would it be to create ?

    Any input would be gratefully appreciated.

  2. #2
    New Member
    Join Date
    Jun 2010
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Criteria Dynamic Filter Temple

    I can see that being handy with a variety of applications. Good luck.

  3. #3
    New Member
    Join Date
    Jul 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Criteria Dynamic Filter Temple

    Anyone ?

  4. #4
    New Member
    Join Date
    Jul 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple Criteria Dynamic Filter Temple

      
    Nudge. Anyone ?

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com