Results 1 to 2 of 2

Comparing Two Sheets Take Less Than Out of the Duplicates

Threaded View

  1. 10-03-2015, 05:49 PM #1
    ryanb4614
    ryanb4614 is offline
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Comparing Two Sheets Take Less Than Out of the Duplicates

    Sheet1= master field that I am trying to copy the content from the other sheets
    Sheet2= Distributor1 Column A has UPC Column B Price Column C Shipping Price
    Sheet3= Distributor2 Column A has UPC Column B Price Column C Shipping Price

    In Sheet 1 I would like to paste/copy ALL UPC between sheet 2 and sheet 3. If there is a duplicate (comparing UPC) I would like the lesser of the two transferred over (less of the two column B price not worried about shipping).

    I have been trying this all day and cannot get it. Tried copying all UPC to Sheet 1 from both sheets marked the duplicates i just can't get it to work so I don't have duplicated products. Any ideas what would be the easier way and a possible solution?
    Last edited by ryanb4614; 10-03-2015 at 05:53 PM.
    Reply With QuoteRegister To Reply
« 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. Comparing Data and Duplicates
    By sweedey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 04:59 PM
  2. Comparing one column to another for duplicates
    By cmp3182 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-25-2013, 09:28 AM
  3. Comparing data with duplicates
    By Zapster310 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 03:50 PM
  4. Comparing two columns for duplicates
    By michaelrusk in forum Excel General
    Replies: 1
    Last Post: 07-16-2012, 09:18 AM
  5. [SOLVED] Comparing data between 2 sheets to find duplicates
    By redheadinlove in forum Excel General
    Replies: 14
    Last Post: 05-30-2012, 09:43 PM
  6. Comparing Two Lists for Duplicates
    By ComcoDG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2011, 02:29 PM
  7. Duplicates in comparing two columns
    By sammyd323 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2007, 10:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1