+ Reply to Thread
Results 1 to 3 of 3

Need help with SKU generation from product attributes in columns

  1. #1
    Registered User
    Join Date
    06-22-2013
    Location
    Guernsey
    MS-Off Ver
    Excel 2010
    Posts
    7

    Need help with SKU generation from product attributes in columns

    Hi all

    I have a spreadsheet of products that I would like to generate SKU's from.

    This isn't the usual number generator I have come across but what I really want to achieve is something like this:

    Column B Column C Column D Column E
    Manufacturer Description Size Colour

    Output to Column A would be a SKU that takes the first 3 characters of each of the referenced columns, IE: MAN-DES-SIZ-COL

    If we were selling an Apple Iphone 16gb in white our SKU would be APP-IPH-16G-WHI

    Ideally some error checking would be good to ensure we don't get duplicates, if so have them flagged for manual intervention.

    Would really appreciate any help, hopefully this is easy for someone and I am not asking for the moon on a stick!

    Thanks

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need help with SKU generation from product attributes in columns

    IN a2 =LEFT(B2,3)&"-"&LEFT(C2,3)&"-"&LEFT(D2,3)&"-"&LEFT(E2,3)
    then for checking in column F f2 =IF(COUNTIF($a$2:a2,a2)>1,"duplicate","ok") filled down
    Last edited by martindwilson; 12-05-2013 at 01:38 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-22-2013
    Location
    Guernsey
    MS-Off Ver
    Excel 2010
    Posts
    7

    Thumbs up Re: Need help with SKU generation from product attributes in columns

    martindwilson that is exactly the ticket, thank you very much for your help. Legend

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic chart generation from 200 columns
    By boyboy400 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-06-2013, 05:51 PM
  2. [SOLVED] Search multiple attributes across several columns, VBA Advanced Filtering
    By dannyjoer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 06:48 AM
  3. Replies: 5
    Last Post: 07-28-2011, 04:24 AM
  4. I have two columns (A) and (G) that have like product codes however
    By genesisoxygen@gmail.com in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 03:25 PM
  5. Sum Product if? Three columns
    By gmunro in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-02-2006, 11:05 AM

Tags for this Thread

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