Results 1 to 20 of 20

DATA across 3 columns and output to 4th

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    India
    MS-Off Ver
    MS OFFICE 2013 x64
    Posts
    19

    Post DATA across 3 columns and output to 4th

    Dear all,

    I have a certain Excel workbook which has data stored in 3 columns. Column A has around 300 entries, column B has around 980 and similar for column C. There are certain similar entries between columns A and B.

    What I wish to do is to find all the similar entries between A & B, then match it to the corresponding entry in column C and then give a output in the same worksheet

    I'm attaching the sample for easier understanding and analysis

    Any guidance would be appreciated, solving this basically finishes my entire project
    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. [SOLVED] Compare columns A and B and output data in A that is NOT in B?
    By steviec in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2015, 12:17 PM
  2. Replies: 6
    Last Post: 12-06-2012, 11:05 AM
  3. Replies: 6
    Last Post: 11-18-2010, 05:12 AM
  4. Looping through columns to copy output into other sheet, and saving output
    By eludlow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2009, 06:27 AM
  5. Replies: 20
    Last Post: 04-04-2007, 05:36 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