+ Reply to Thread
Results 1 to 2 of 2

Only Return Values that Satisfy Both Filters

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Only Return Values that Satisfy Both Filters

    I have a worksheet that contains Country Abbreviations and related Codes. Some countries have multiple codes. How would I search for two countries and have it return me only the codes that are related to BOTH countries and not just one country.

    Example:
    Code Country
    1 USA
    2 GBR
    3 HON
    4 GBR
    4 USA
    5 HON
    6 USA
    6 HON
    6 GBR

    If I typed in or selected USA and GBR it would only return 4 and 6, not 1 and 2. If I use filters it returns 1, 2, 4, and 6.

    I have to do these searches often so I'm hoping to be able to type in the three-letter country abbreviations or be able to select them from a list and it return the correct code(s).

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Only Return Values that Satisfy Both Filters

    Hello and welcome.
    This can be done with helper column.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. Replies: 3
    Last Post: 12-13-2013, 06:23 AM
  2. Function that filters on criteria in row to return percentile number.
    By brandnew22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2013, 02:24 AM
  3. Extracting unique values (without using filters)
    By stevemyers in forum Excel General
    Replies: 4
    Last Post: 09-20-2010, 04:39 PM
  4. Analyzing a range for a conditional and returning all values that satisfy it
    By drummerboy1023 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-12-2010, 01:53 PM
  5. Using ComboBox Values To Activate Filters
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2009, 03:35 AM

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