+ Reply to Thread
Results 1 to 2 of 2

Filter columns with multi values

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    1

    Filter columns with multi values

    Hi!

    I have a sheet looking something like this:

    Name; Interests
    Daniel; Football, Ice hockey, Golf
    Eric; Ice Hockey, Golf
    Aron; Football, Golf
    Linda; Football, Ice hockey

    What I want to do is to filter on column "Interests" and match out rows containing Golf, but not Ice Hockey or Football.

    In the built in filter feature of Excel I can filter on text "containing" Golf and add a "contains not" Ice Hockey, what I would like to do is to add extra conditions to the "contains not" field.


    Hope someone has come ideas about it!
    Last edited by coolvik; 08-31-2010 at 08:23 AM.

  2. #2
    Forum Contributor
    Join Date
    04-07-2009
    Location
    Rowley
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Filter columns with multi values

    This does not use a FILTER, but you might find it helpful:

    PHP Code: 
       A                  B
    1
    Name       Interests
    2
    Daniel     FootballIce hockeyGolf
    3
    Eric       Ice HockeyGolf
    4
    Aron       FootballGolf
    5
    Linda      FootballIce hockey 
    In Cell C2 enter the formula:

    =IF($D$1=0," ",IF(ISERROR(FIND(LOWER($D$1),LOWER(B2),1)),"No","Yes"))

    Drag down 3 rows.

    In Cell D1 enter the text word Golf

    The formula in column C will find if the target word is there and display
    either YES the word has been found or NO the word does not appear.

    Simply change the word in Cell D1 to search for a different word.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1