Results 1 to 9 of 9

Compare four columns, give "yes" or "no" answer

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2009
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    15

    Compare four columns, give "yes" or "no" answer

    Hello! This is my first time posting- I would like to thank everyone for all of the great answers. This time I can't seem to find exactly what I need on another thread, so I thought I would post my own.

    I have the attached worksheet with clients' names in four columns (A-D). The first names and last names must remain separate. I need one additional column that shows whether a full name (first and last) in C and D also appears in A and B.

    Then one more column that shows how many times the name in C and D shows up, but only if it is also in A and B.

    I hope that isn't too confusing. Thanks!

    Lauren
    Attached Files Attached Files
    Last edited by LaurenR; 09-17-2009 at 03:53 PM.

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