+ Reply to Thread
Results 1 to 2 of 2

Comparing a list of names to another list of hyperlinked names to highlight similar

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Comparing a list of names to another list of hyperlinked names to highlight similar

    Have a roster of names, all hyperlinked to their individual sheets and I have a roster of names that have been updated to reflect current employees. How would one compare the list and highlight any names that do not have a counter part so I can delete them, or highlight names that do have a counterpart?

    The hyperlink roster is in Last Name, First Name format while the updated roster is just First Name Last Name

    I think my attached workbook is pretty close to my actual sheet and should make it pretty obvious in case my explanation above was confusing!
    Attached Files Attached Files
    Last edited by taylorsm; 07-25-2016 at 09:18 AM.

  2. #2
    Registered User
    Join Date
    05-11-2016
    Location
    Liberty Lake, Washington
    MS-Off Ver
    2010
    Posts
    79

    Re: Comparing a list of names to another list of hyperlinked names to highlight similar

    Solution attached.

    First I used a formula to rearrange what I assume will be last and first names separated by a comma to match your new list.

    Then a formula to check for matches in the new list.

    Then conditional formatting to highlight any marked as "No Match."

    Let me know if you have any questions!
    Attached Files Attached Files

+ 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. [SOLVED] deleted the post
    By joparo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2015, 07:00 AM
  2. Replies: 2
    Last Post: 01-07-2015, 07:15 PM
  3. [SOLVED] Draw random names from list and then remove, carry on till no names left in list
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:14 PM
  4. Finding similar names (text) in a list
    By hussmanne in forum Excel General
    Replies: 7
    Last Post: 07-24-2013, 02:08 AM
  5. Comparing list of names in different formats
    By chad portman in forum Excel General
    Replies: 3
    Last Post: 01-15-2013, 04:26 PM
  6. Finding and deleting a small list of names from a really big list of names
    By vitalstatistix in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-07-2011, 01:31 PM
  7. [SOLVED] comparing names in a list
    By ferde in forum Excel General
    Replies: 6
    Last Post: 03-22-2006, 01:20 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