Results 1 to 6 of 6

Find all matches, count them and return all the corresponding items

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    São Paulo, Brazil
    MS-Off Ver
    Excel 2019
    Posts
    19

    Find all matches, count them and return all the corresponding items

    Hello, guys!

    I need your help once again.
    I tried to solve it myself using Pivot Table, INDEX/MATCH and even MS Query/SQL with no avail... It's apparently simple but I can't figure it out.
    So, I have two columns: Column A with product names and Column B with raw materials.
    I need some function, VBA, Pivot Table, anything, to check:

    1) How many raw materials each product has in common.
    2) What the products are.

    Let me illustrate it to you:

    Prod RawMat
    W A
    W B
    W C
    W D
    X B
    X F
    X G
    Y C
    Y G
    Y H
    Z B
    Z C
    Z G

    Result expected

    - Product W has 2 raw materials in common (B and C). Corresponding products for B= X and Z. For C= Y and Z.
    - Product X has 2 raw materials in common (B and G) . Corresponding products for B= W and Z. For G= Y and Z.
    - Product Y has 2 raw materials in common (C and G). Corresponding products for C= W and Z. For G= X and Z.
    - Product Z has 3 raw materials in common (B, C and G). Corresponding products for B= W and X. For C= W and Y. For G= X and Y.

    I hope I have made myself clear.

    Thanks in advance for your help!

    Rgds,
    Gustavo.
    Last edited by strabgus; 06-25-2014 at 09:43 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare 2 Columns of Data
    By joshuacoates in forum Excel General
    Replies: 5
    Last Post: 02-06-2013, 01:05 AM
  2. Replies: 1
    Last Post: 01-15-2013, 01:23 PM
  3. Compare columns of data
    By Tortus in forum Excel General
    Replies: 5
    Last Post: 01-26-2009, 03:11 PM
  4. [SOLVED] Compare data in two columns
    By excellearn2006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2006, 06:15 PM
  5. compare data from 2 columns
    By micmed in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2006, 10:55 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