+ Reply to Thread
Results 1 to 1 of 1

Filtering list created by custom text filters

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    Prague, Czech Republic
    MS-Off Ver
    2007
    Posts
    1

    Lightbulb Filtering list created by custom text filters

    Hello,

    I am looking for a solutions for this challenge I am trying to solve.

    I have a column, in which cells contains many different recurring text, which I need to filter by contains. I know about option in "Text filters" - "Contains", however this lets me to choose one specific filter, which I must then clear and create new if I want to choose new word to filter. I know about saving views, however, I need this to be easily usable for anyone I send this file to - therefore, I am looking for a solution, where I could implement my own Contains Filtering into existing list in filtering.

    For this case I have created an example of farms which grows different plants. Table looks like this.
    table.jpg
    As you can see, there are farms, and each farm grows different plants.

    If I want to filter Farms by Plants they grow, I have option 1 - to choose from an automatic list which lets me filter just by exact sentences in the cells, or I can use "Text filters" - "Contains" to choose exact word of Plant by which I want to filter the Farms. What I am looking for is a solution, where the automatic list would contain specific custom filters by "Text filters" - "Contains".

    To make it clear, I want this list...
    list.jpg

    ...to be transformed into something like this:
    wantlist.jpg

    So it would be very easy for anyone who gets my table to select criteria by which he wants to filter out provided information

    Is there any solution to this? I am using MS Word 2007, so I am looking for solution mainly for this, but if there is the solution in newer Words (2010, 2013, ...), please, add answer at least for them. I am able to get to computer with newer Word and also this should be helpful also for anyone who might want to overcome similar challenge but is using newer Word.

    Thank you very much!
    Last edited by stilki; 06-23-2014 at 07:02 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering Without Filters
    By frith in forum Excel General
    Replies: 6
    Last Post: 02-23-2013, 08:22 PM
  2. Auto Filtering Macro that Filters for more than one item
    By murph8868 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2013, 03:18 PM
  3. Custom filters?
    By norm01 in forum Excel General
    Replies: 2
    Last Post: 01-06-2011, 04:07 PM
  4. Custom Filters
    By Trisha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2006, 04:34 PM
  5. [SOLVED] Custom filters
    By Pete in forum Excel General
    Replies: 3
    Last Post: 04-20-2006, 09:35 AM

Tags for this Thread

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