Results 1 to 6 of 6

Comparing Columns with Matching Results Listed in One Cell

Threaded View

  1. #3
    Registered User
    Join Date
    11-20-2013
    Location
    RI
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Comparing Columns with Matching Results Listed in One Cell

    Thanks for the quick response. I will try to give a simplified example of what I need. If I had the following in columns A-D, I would like to be able to get the comparison results listed in E as shown below.

    A B C D E
    1 x x y x x,z (Comparison matches between columns A and B)
    2 y z z y y,z (Comparison matches between columns A and C)
    3 z x,y (Comparison matches between columns A and D)
    4 z (Comparison matches between columns B and C)
    5 x (Comparison matches between columns B and D)
    6 y (Comparison matches between columns C and D)

    I hope this helps explain what I need.

    Thanks again,
    Chad
    Last edited by mako_cc; 11-20-2013 at 11:30 PM. Reason: Fixing the spacing to look like a real table.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-18-2013, 05:56 PM
  2. NEED HELP - Columns data matching and moving results to another cell
    By monteiro1969 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-07-2012, 10:11 AM
  3. [SOLVED] comparing two columns and moving down the cell which is not matching
    By sutapa892011 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-26-2012, 10:56 PM
  4. Excel 2007 : Comparing and matching two text columns
    By Bizzielizzie in forum Excel General
    Replies: 2
    Last Post: 04-11-2012, 09:50 AM
  5. Comparing data and matching between columns
    By bunjijumper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2010, 02:58 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