+ Reply to Thread
Results 1 to 3 of 3

Finding Duplicate Rows in 2 spreadsheets

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    30

    Finding Duplicate Rows in 2 spreadsheets

    I know that this has been discussed at some point but for the life of me I cannot find a solution to my issue. If someone could help me with this I would appreciated it.

    I have 2 spreadsheets in 1 workbook. One tab is named MASTER and the other tab is named WORKSHEET. Both spreadsheets are identically setup with 3 columns titled UPC, Stockcode, Division. What I want to do is match the rows on the worksheet spreadsheet to the master spreadsheet.

    The formula or macro needs to take the first row in the worksheet spreadsheet and then look for a match in the master spreadsheet, all 3 columns of data must match exactly when compared to each spreadsheet.

    Example

    MASTER
    UPC STOCKCODE DIVISION
    1234567890 123456 KANSAS CITY
    2222222222 323232 FORT WORTH
    3333333333 414141 OKLAHOMA

    WORKSHEET
    UPC STOCKCODE DIVISION
    1234567890 123456 MEMPHIS
    2222222222 323232 FORT WORTH
    3333333333 414141 NASHVILLE

    Note: In this example there is only one true match where all 3 columns are in the same row.

    Basically all I want done is to have the matched rows highlighted or identified in some way on the "WORKSHEET", so as too make them easily identifiable.

    Hope that makes sense.
    Last edited by eagle670; 06-11-2012 at 02:48 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Finding Duplicate Rows in 2 spreadsheets

    Post a example of your worksheet (without confidential information).

    If you also post the desired result (in your shee), you will get better help.

  3. #3
    Registered User
    Join Date
    03-28-2012
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Finding Duplicate Rows in 2 spreadsheets

    I tried to upload the file but it say it is too large, I tried to zip it but it still will not attach. Basically all I want done is to have the matched rows highlighted or identified in some way on the "WORKSHEET", so as too make them easily identifiable.

+ 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