Results 1 to 5 of 5

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

  1. #1
    Seeker pbsmith82's Avatar
    Join Date
    May 2016
    Posts
    9
    Articles
    0
    Excel Version
    Excel 2016

    Generating Semi Unique ID's based off Multiple Criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Let me first state I have cross posted this but I haven't been able to get an answer. You can find that post at: https://www.mrexcel.com/forum/excel-...criterias.html

    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 = Yes, & Parent Company Matches, I need it to copy the first 5 digits of the Account Number, then put an E on the end. If that Enterprise ID has already been Created for that Same particular PRODUCT then 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.

    Click image for larger version. 

Name:	Capture568.PNG 
Views:	13 
Size:	77.0 KB 
ID:	9127

    Excel Guru.xlsx



  2. #2
    Seeker pbsmith82's Avatar
    Join Date
    May 2016
    Posts
    9
    Articles
    0
    Excel Version
    Excel 2016

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,184
    Articles
    0
    Excel Version
    Office 365 Subscription
    You seem to have started a habit of cross-posting. This should not be your default behaviour, as you may find that members of each of the forums start ignoring your posts. They won't bother helping if they always have to check other forums to see if you've had responses. Cross-posting should only be necessary if you can't get an aswer on the first forum to which you post.

    Please post a link to the THIRD forum where you have asked this question.

    Please read the section on cross-posting here: https://www.excelguru.ca/content.php?184
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Seeker pbsmith82's Avatar
    Join Date
    May 2016
    Posts
    9
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by AliGW View Post
    You seem to have started a habit of cross-posting. This should not be your default behaviour, as you may find that members of each of the forums start ignoring your posts. They won't bother helping if they always have to check other forums to see if you've had responses. Cross-posting should only be necessary if you can't get an aswer on the first forum to which you post.

    Please post a link to the THIRD forum where you have asked this question.

    Please read the section on cross-posting here: https://www.excelguru.ca/content.php?184
    As you can see I posted it before you commented, and yes as I have not been able to find answer Yet so I posted on another forum.

  5. #5
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,184
    Articles
    0
    Excel Version
    Office 365 Subscription
    You still have not provided a link to the third forum where you asked the same question. Please do so. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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