Results 1 to 3 of 3

Thread: Generating Semi Unique ID's based off Multiple Criteria's
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Generating Semi Unique ID's based off Multiple Criteria's

    I am trying to have the spreadsheet to Auto Generated an ID for me. I need this ID to Reference together 3 different Products into a Single Project.
    At the bottom I have included a link to a Sample Workbook & Picture.


    ENTERPRISE PROJECT A: (Composed of three different Products)


    • MIL Site | ID: 10071E
    • CRM | ID: 10071E
    • IH & Lite CMB | ID: 10071E



    ENTERPRISE PROJECT B: (Composed of Two different Products)


    • MIL Site | ID: 10071E.1
    • IH & Lite CMB | ID: 10071E.1





    The basic desire of the formula would be as follows:
    If Enterprise is Yes, & Parent Company Matches, I need it to copy the first 5 digits of the Account Number, put an E on the end. I need it to date for all 3 Products. If that Enterprise ID has already been Created for that proticular PRODUCT it was add a ".1"
    So it would be possible and desired that a MIL SITE, CRM, and IH & LITE CMB would all have the same ENTERPRISE ID, but that ID could NEVER appear more than 3 Times.

    HERE IS A LINK TO SAMPLE WORKBOOK: http://phillipbsmith.com/wp-content/...el-Guru-1.xlsx


  2. #2
    New Member
    Join Date
    May 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Generating Semi Unique ID's based off Multiple Criteria's

    Just wanted to let you know I have cross posted this trying to find an answer. You can find that post at: https://www.excelguru.ca/forums/show...tiple-Criteria. Still no answer as of yet.

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Generating Semi Unique ID's based off Multiple Criteria's

    https://www.excelforum.com/excel-for...-criteria.html - Cross posted since I still haven't been able to find an answer.
    Last edited by pbsmith82; May 26th, 2019 at 10:24 AM. Reason: Note

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •