+ Reply to Thread
Results 1 to 3 of 3

Help with list filtering function

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help with list filtering function

    My spreadsheet is set up like this:
    Column A contains a list of names.
    Column B contains a 'y' or 'n'
    Column C contains a 'y' or 'n'

    On sheet 2 I want a separate list to be created with only the names that have a 'y' in column B and a 'y' in column C to show up.

    The function I have so far is below. 'A' designates the range in column A, 'B' for column B.

    =IFERROR(INDEX(A, SMALL(IF(B<>"y", "", ROW(A)-MIN(ROW(A))+1), ROW(A1))),"")

    This function creates a list with only the names that have a 'y' in column B. I don't know how to expand this formula to only take the names with 'y' in column C as well.

    Help please? Thanks in advance.
    Last edited by imperitor; 11-26-2012 at 02:21 PM.

  2. #2
    Registered User
    Join Date
    08-23-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Help with list filtering function

    Add another IF Function in the IFERROR[value_if_error] argument
    A macro does what you tell it, not what you want.

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help with list filtering function

    Ah thanks! That worked. I was trying a AND function within the IF before and that wasn't working for some reason.

+ 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