+ Reply to Thread
Results 1 to 3 of 3

Create new row of data for duplicate entries in column

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Create new row of data for duplicate entries in column

    I am trying learn how to create a new row of date when there is a duplicate entry in a column. What I am doing, is trying to figure out when someone purchases product A, what product B are they also purchasing. So I have two sheets of data, sheet 1 lists the invoice #'s and which product A they purchased; sheet 2 lists the invoice#'s and which product B they purchased. I created a column in sheet 2 for product A, and I have been using the formula "=INDEX(Sheet1!B:B,(MATCH(Sheet2!A2,Sheet1!A:A,0)))" This formula works for great for matching product A with product B, but it does not take into account when more than one Product A or Product B was purchased on the same invoice.

    I have attached a sample document. Any help would be greatly appreciated. Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Create new row of data for duplicate entries in column

    Here is an attachment with what I would like the final spreadsheet to look like; having created an additional row for each duplicate.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Create new row of data for duplicate entries in column

    Anybody have a suggestion? Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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