+ Reply to Thread
Results 1 to 2 of 2

Name Mismatch

  1. #1
    Registered User
    Join Date
    12-13-2015
    Location
    Addis Ababa
    MS-Off Ver
    2010
    Posts
    7

    Name Mismatch

    Hi Guys

    How do I identify name mismatch between two columns. Each cell has a person’s last name followed by a backward slash then his first and middle name afterwards (middle name might not always be included). Please check out the attachment.Name.xlsx
    If one of the three names on the first column is similar to any type of the names on the second then I want it to mark as acceptable. I am a dummy when it comes to Excel and I’d appreciate it if anyone can help me on this. Thanks

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello hiruyg,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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] Do a SUM if there's a Mismatch
    By inn in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-10-2014, 01:12 AM
  2. name mismatch
    By turnej in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-07-2013, 08:36 PM
  3. VBA mismatch
    By tajennens in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2012, 09:31 AM
  4. If - else type mismatch
    By michaelkwc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2008, 05:14 AM
  5. Mismatch error
    By danielhliu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2008, 03:17 PM
  6. Type Mismatch
    By cruzader777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2007, 05:57 AM
  7. another type mismatch
    By marcmarc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2007, 04:27 PM
  8. type mismatch
    By Mikeyhend in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2006, 01:17 PM

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