+ Reply to Thread
Results 1 to 7 of 7

trying to create product control numbers using item number, month, year and alpha criteria

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    SC, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Lightbulb trying to create product control numbers using item number, month, year and alpha criteria

    I have been away from Excel for a while and now I need to create a formula to capture an item number, two digit month, two digit year and an alpha code i.e.

    item #: 0001
    month: 05
    year: 13
    alpha code: CS

    code result should be 00010513CS

    item #: 0002
    month: 06
    year: 13
    alpha code: GC

    code result should be 00020613GC

    And so on. Does anyone know how to achieve this?

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: trying to create product control numbers using item number, month, year and alpha crit

    is the item #, month, year and code all in one cell or 4 rows?
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: trying to create product control numbers using item number, month, year and alpha crit

    how is your data layed out, are the Item #, Month Year and Alpha Code column headers or are they row labels?

    i attached a sample solution that has a few variations of the data
    sample solution.xlsx

  4. #4
    Registered User
    Join Date
    05-22-2013
    Location
    SC, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Red face Re: trying to create product control numbers using item number, month, year and alpha crit

    Thanks for your reply...

    Right now i have everything set up in columns and would like to populate the control number automatically.

  5. #5
    Registered User
    Join Date
    05-22-2013
    Location
    SC, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: trying to create product control numbers using item number, month, year and alpha crit

    Quote Originally Posted by scott.s.fower View Post
    how is your data layed out, are the Item #, Month Year and Alpha Code column headers or are they row labels?

    i attached a sample solution that has a few variations of the data
    Attachment 237548
    I see that you're sample solution works but for some reason it doesn't in my spreadsheet so I've attached a sample of what I'm doing so you can see it directly.

    I greatly appreciate your assistance!
    Attached Files Attached Files

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: trying to create product control numbers using item number, month, year and alpha crit

    give this a try in F2 and then copy it down the column

    Please Login or Register  to view this content.

  7. #7
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: trying to create product control numbers using item number, month, year and alpha crit

    Glad I could help....Please change the Post to Solved as to keep the moderators happy.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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