Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2007
    Location
    Cape Town, Western Cape, South Africa
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I have information in column A,B and C. The want to filter the information that is in colunm A e.g if the a name in column A is not in colunm B and C, it must not appear on the list. I have attached the spreadsheet
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can do this with some auxiliary formulas and AutoFilter, see the attached workbook.

    Formulas in column D are of the form =B2&" "&C2; they return the full name.
    Formulas in column E are of the form =NOT(ISERROR(MATCH(A2,$D$2:$D$264,0))); they return TRUE if there is a match, FALSE if there isn't.
    AutoFilter is used to show only the TRUE values in column E.
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='774638' date='11-May-2009 08:34']................Formulas in column E are of the form =NOT(ISERROR(MATCH(A2,$D$2:$D$264,0)))...........[/quote]

    HansV's formula at cell E2

    =NOT(ISERROR(MATCH(A2,$D$2:$D$264,0)))

    Since,

    "NOT(ISERROR" is equal to "ISNUMBER"

    Thus, the formula can write as :

    =ISNUMBER(MATCH(A2,$D$2:$D$264,0))


    Regards
    Bosco

Posting Permissions

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