+ Reply to Thread
Results 1 to 4 of 4

Compare column D to B, acknowledge duplicates & move values in D while keeping rows intact

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Compare column D to B, acknowledge duplicates & move values in D while keeping rows intact

    Hiya!

    Every week I do price changes, and it's about time I find a simpler way to keep product prices up-to-date.

    Column A = AMZN SKUs
    Column B = BB Codes 1
    Column D = BB Codes 2
    Columns E and beyond = product information and new prices related to the BB Codes 2

    Because there are sometimes multiple AMZN SKUs for a single BB Code, I need a script that will acknowledge duplicate values in Column B.

    In conclusion, I need a script that will compare column D to B, acknowledge that there are duplicates in Column B, match values in Column D to Column B, and move data in D and beyond while keeping the rows intact.

    Example:
    4SnDBNd.jpg

    I hope this is possible, or at least something close to it. Thanks, everybody!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: Compare column D to B, acknowledge duplicates & move values in D while keeping rows in

    Hi,

    Like this?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Compare column D to B, acknowledge duplicates & move values in D while keeping rows in

    Yes, that's exactly how I would want it to look.

    Did you run anything on this sheet? I noticed that ACQ90 did not match up with the other ACQ90's.

  4. #4
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: Compare column D to B, acknowledge duplicates & move values in D while keeping rows in

    Hi,

    Sorry,

    I changed some data accidentally while testing the formulas...

+ 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