+ Reply to Thread
Results 1 to 5 of 5

Finding Duplicate Items on 2 Different Sheets

  1. 08-13-2015, 12:57 PM #1
    berman53
    berman53 is offline
    Registered User
    Join Date
    03-23-2015
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    21

    Finding Duplicate Items on 2 Different Sheets

    Hello Everyone!

    I have a bit of a situation and I'm hoping you guys/gals can help me out. I attached a sheet so you can see what I'm working with. If you look at column A in sheet labeled "Order" you see a list of SKU's. Then on Sheet labeled "Overstock" you see another list of SKU's. I'm trying to see if any of the SKU's in Overstock column A match up with the Order Column A. Is there a formula that would help me figure this out? Hopefully that makes sense. Thank you for any help you can give!OS Warehouse.xlsx
    Reply With QuoteRegister To Reply
  2. 08-13-2015, 01:07 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Finding Duplicate Items on 2 Different Sheets

    Put this in a helper column (I used G. It will tell you the row number of the duplicates
    =IFERROR(MATCH(A2,Overstock!A:A,0),"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 08-13-2015, 01:40 PM #3
    berman53
    berman53 is offline
    Registered User
    Join Date
    03-23-2015
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Finding Duplicate Items on 2 Different Sheets

    You guys are the best just saved me hours worth of work. Thank you and that solved my problem.
    Reply With QuoteRegister To Reply
  4. 08-13-2015, 01:59 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Finding Duplicate Items on 2 Different Sheets

    Happy to help, and thanks for the kind words

    If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
    Reply With QuoteRegister To Reply
  5. 08-13-2015, 02:06 PM #5
    berman53
    berman53 is offline
    Registered User
    Join Date
    03-23-2015
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Finding Duplicate Items on 2 Different Sheets

    You got it. Thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding/moving duplicate entries across multiple sheets
    By madbloke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 02:13 PM
  2. Finding Duplicate Serial Numbers in multiple sheets
    By leeaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2013, 12:33 AM
  3. Finding duplicate records across multiple sheets within a workbook
    By jimmyi189 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2012, 02:20 PM
  4. Finding duplicate across many sheets
    By hero96559 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-28-2012, 08:38 AM
  5. Finding duplicate data between sheets
    By Nickgarn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2010, 06:09 PM
  6. Finding/Matching Items
    By stevemyers in forum Excel General
    Replies: 4
    Last Post: 08-10-2010, 11:16 AM
  7. Vlook up for finding 2 same items
    By jeevan in forum Excel General
    Replies: 1
    Last Post: 01-13-2009, 06:27 AM
  8. How to get rid off duplicate items?
    By Svea in forum Excel General
    Replies: 5
    Last Post: 10-23-2005, 08:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1