Closed Thread
Results 1 to 4 of 4

Matching names from different columns..

  1. 08-18-2014, 03:18 PM #1
    jkim204
    jkim204 is offline
    Registered User
    Join Date
    07-24-2014
    Location
    Atlanta, Georgia
    MS-Off Ver
    2007
    Posts
    15

    Matching names from different columns..

    Hey everyone,

    I am at work and I need some help!
    I have two columns listing about 400 and 500 names respectively.
    First Column has names in alphabetical order and the second column is random.
    One column has names in this format: Last name, First name
    and the other column lists the names as first name and then last name without the comma
    I am trying to see if the list of names in one column exists in the other.

    Is there a way to see this without changing the format of the names in each column? If so do I have to erase the comma?

    Thanks in advance !

    Name Lists (1).xlsx
    Reply With QuoteRegister To Reply
  2. 08-18-2014, 03:26 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Matching names from different columns..

    duplicated post

    http://www.excelforum.com/excel-form...nd-column.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 08-18-2014, 03:32 PM #3
    jkim204
    jkim204 is offline
    Registered User
    Join Date
    07-24-2014
    Location
    Atlanta, Georgia
    MS-Off Ver
    2007
    Posts
    15

    Re: Matching names from different columns..

    Quote Originally Posted by oeldere View Post
    duplicated post

    http://www.excelforum.com/excel-form...nd-column.html
    Are u still not able to open it?

    The guy who drew the graph got the main idea it's just that the formula answers some as true when it should be false and vice versa. I don't understand why.. Use this data then and try it please

    1st column

    Addie, Shameka
    Alexander, Shy'Kimeyun
    Avery, Meriel F
    Bailey, Gwendolyn M
    Bailey, Jill
    Bartlett, Ken
    Barton, Steven G
    Beasley, Alicia
    Benjamin, Augusta L.
    Blackmon, Patricia
    Blackmon, Wykethia
    Blocton, Robert
    Boddie, Mattie
    Bollinger, Aaron
    Bolton, Larry
    Bonner, Shineka
    Booker, Traci
    Bowles, Walter D
    Boyd, Toya C
    Boykin, Avaonce
    Boykin, Ronnie M.
    Braxton, Chiquita N
    Briskey, Kendra
    Brooks, Brandon
    Brooks, Donavian
    Brooks, Jamie E
    Brown, Lashonda Y
    Buchanan, Donkorski

    2nd column

    Aaron Bollinger
    Aaron Bollinger
    Akia Putnam
    Akia Putnam
    Alfrica Ross
    Allison Benton
    Allison Benton
    Amy Newsome
    Amy Newsome
    Anita Hill
    Anita Hill
    Ann Rushin
    Anthony Patterson
    Anthony Patterson
    Antoine Shandifor
    April Childs
    Aprill Simmons
    Barbara Lee
    Bettie Jordan
    Bettie Jordan
    Blake Willoughby
    Blake Willoughby
    Bobbie Core
    Bobbie Core
    Brenda Foreman
    Brenda Foreman
    Brenda Gunn
    Brian May
    Last edited by jkim204; 08-18-2014 at 03:34 PM.
    Reply With QuoteRegister To Reply
  4. 08-18-2014, 03:51 PM #4
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Matching names from different columns..

    The file from your previous thread can be downloaded/viewed. Closing this thread.
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. Look up and compare names from two columns, matching issues
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2012, 02:16 PM
  3. 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
  4. Line matching names in two seperate columns
    By eskapetoreality in forum Excel General
    Replies: 0
    Last Post: 04-17-2005, 07:10 PM
  5. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1