+ Reply to Thread
Results 1 to 12 of 12

Generating Semi Unique ID's based off Multiple Criteria

  1. #1
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

    Exclamation Generating Semi Unique ID's based off Multiple Criteria

    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.
    Attached Images Attached Images

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    7,603

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

    Links added as text by OP and under normal form by me
    Last edited by Pepe Le Mokko; 05-27-2019 at 02:11 AM.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,913

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

    Welcome to the forum!

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

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

    I have cross posted this but this site won't let me included the link........ I have pointed those post to this thread but haven't able to add the link to this post. I can't seem to find an answer.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,913

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

    On which other site have you cross-posted?

  6. #6
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

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

    It wouldn't allow me to add the links as text I tried .... It just kept tell me It was a URL: I tried and Updated those post to reflect this thread. It would even allow me to quote you as your quote includes a link .
    Last edited by AliGW; 05-26-2019 at 10:36 AM.

  7. #7
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

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

    Quote Originally Posted by AliGW View Post
    On which other site have you cross-posted?
    Thank you .... Excel Guru and Mr Excel .... Both have the sample workbook you asked for. I am going to see if it will allow me to link it again but so far it hasn't .....
    excelguru.ca/forums/showthread.php?10008-Generating-Semi-Unique-ID-s-based-off-Multiple-Criteria
    mrexcel.com/forum/excel-questions/1098832-generating-semi-unique-ids-based-off-multiple-criterias.html#post5283630


    Edit mod
    https://www.excelguru.ca/forums/show...tiple-Criteria
    https://www.mrexcel.com/forum/excel-...criterias.html
    Last edited by Pepe Le Mokko; 05-27-2019 at 02:11 AM. Reason: added links under usable form

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,913

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

    Thanks.

    Please attach your workbook here if you wish for help here.

  9. #9
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

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

    Quote Originally Posted by AliGW View Post
    Thanks.

    Please attach your workbook here if you wish for help here.
    Absolutely when I first tried it wouldn't let me ....... but I will try again.

    Nope still doesn't allow me ... See image .... How am I suppose to include links to cross posted, or Attach workbook if the site doesn't allow me to do these things?

    Doesn't allow me.PNG

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,913

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

    I said this:
    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  11. #11
    Registered User
    Join Date
    05-26-2019
    Location
    Miami, FL
    MS-Off Ver
    Office 2016
    Posts
    6

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

    Quote Originally Posted by AliGW View Post
    I said this:
    I am SOOOO Sorry. I apologize. I usually wouldn't miss something like that. Thanks so much for the help.
    Here is the workbook.
    Attached Files Attached Files

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,913

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

    You are bound to get yourself in a bit of a muddle posting on so many different forums ... As I have pointed out elsewhere, it's not a good idea to get a reputation for doing so every time you post for help. Read this to find out why: https://www.excelguru.ca/content.php?184

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1