Results 1 to 22 of 22

Formulas to see if names in one column exists on the names in the second column

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2014
    Location
    Atlanta, Georgia
    MS-Off Ver
    2007
    Posts
    15

    Formulas to see if names in one column exists on the names in the second column

    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
    Last edited by jkim204; 08-18-2014 at 03:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 01-08-2014, 01:56 PM
  2. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  3. Excel Names in column to text files names to folder
    By excelaron in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2013, 07:22 PM
  4. Replies: 5
    Last Post: 01-13-2012, 03:20 PM
  5. Replies: 2
    Last Post: 11-19-2011, 01:14 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