Results 1 to 5 of 5

Finding similar items between two excel columns and puth them in the new column

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    76

    Finding similar items between two excel columns and puth them in the new column

    Hi all friends,
    I have an easy question for you.
    I have two large columns, one is "data" plus a number in parentheses and another is "reference" (please take a look at the attached sample). "data" column is the part of "reference"; I would like to put the similar items from "data" column with "reference" in the new column (the third column), something like colored in red in the attached sample. Please help me out how I can do it?

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 09-11-2015, 04:01 PM
  2. [SOLVED] To compare a list of items in column ? with items in all columns that are not blank.
    By JamesJohnson31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2015, 03:32 PM
  3. Replies: 5
    Last Post: 01-30-2014, 09:40 AM
  4. Grouping similar items in excel
    By makmool in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 06:01 AM
  5. Finding a date in a specific column surounded by other columns with similar dates
    By Freakazoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2012, 05:28 AM
  6. [SOLVED] counting similar items in a column
    By bj in forum Excel General
    Replies: 5
    Last Post: 06-06-2005, 06:05 PM
  7. Finding similar data or numbers in two columns
    By sayemasof in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-01-2005, 04:05 PM

Tags for this Thread

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