Results 1 to 4 of 4

Formula to Flag names in list 1 that do not exist in list 2.

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Formula to Flag names in list 1 that do not exist in list 2.

    Hi all,

    In the attached spreadsheets are two lists of names - note that in each list, there are duplicates - one name can appear in multiple lines.

    I am hoping for some help finding a formula that will Flag (fill the cell with color) names in "Contact List 2" which do not appear in "Contact List 1". If a name in Contact List 2 meets these conditions, all instances of that name should be flagged.

    Thank you so much in advance for your time! Let me know if you have any more information.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Flag if duplicates exist when list is auto-filtered
    By Philster in forum Excel General
    Replies: 5
    Last Post: 11-24-2011, 10:22 AM
  2. Replies: 2
    Last Post: 12-14-2010, 02:21 AM
  3. [SOLVED] find names on list 1 in list 2. list 1 4000 names list 2 400 name
    By Ed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. find names on list 1 in list 2. list 1 4000 names list 2 400 name
    By Ed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. find names on list 1 in list 2. list 1 4000 names list 2 400 name
    By Ed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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