+ Reply to Thread
Results 1 to 8 of 8

Matching and highlighting names within different sheet columns

  1. #1
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Matching and highlighting names within different sheet columns

    Dear all;

    I am looking for your help..!

    How to highlight similar names in two different sheets columns.

    second, to count those matched names.

    best regards
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Matching and highlighting names within different sheet columns

    Please Login or Register  to view this content.
    Try this conditional format formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Matching and highlighting names within different sheet columns

    another approach
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: Matching and highlighting names within different sheet columns

    Quote Originally Posted by popipipo View Post
    Please Login or Register  to view this content.
    Try this conditional format formula
    thank you, could you please put it in the excel sheet
    I've tried it but failed...

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Matching and highlighting names within different sheet columns

    Here it is.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: Matching and highlighting names within different sheet columns

    Quote Originally Posted by azumi View Post
    another approach
    Great;

    is it possible to apply the same formula for columns in two seperate "workbooks"?

    Best regards

  7. #7
    Forum Contributor
    Join Date
    04-01-2014
    Location
    Middle east
    MS-Off Ver
    Excel 2003 /2007/2010
    Posts
    169

    Re: Matching and highlighting names within different sheet columns

    Quote Originally Posted by popipipo View Post
    Here it is.
    Great!
    still one step to finish
    How can this be applied for the same columns in two different workbooks?

  8. #8
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Matching and highlighting names within different sheet columns

    Try this with both workbooks open.

    I did not test it
    Please Login or Register  to view this content.

+ 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. Help Matching Names in 3 columns
    By C.j. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-30-2015, 10:47 AM
  2. [SOLVED] Matching Last Names in Two columns and pick up certain ones
    By Taisir in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-10-2014, 10:44 PM
  3. Matching names from different columns..
    By jkim204 in forum Excel General
    Replies: 3
    Last Post: 08-18-2014, 03:51 PM
  4. Matching Names to Values Using Two Columns
    By Stopwatch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-23-2014, 11:44 AM
  5. [SOLVED] Highlighting matching cells between many columns within a row
    By jackfjo3 in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 05:15 PM
  6. how to find matching names in two columns ??
    By jovak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2007, 05:08 PM
  7. Matching two columns of names in different formats.
    By surplusbc in forum Excel General
    Replies: 0
    Last Post: 03-17-2005, 01:22 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