Generating Semi Unique ID's based off Multiple Criteria

pbsmith82

New member
Joined
May 27, 2016
Messages
10
Reaction score
0
Points
0
Excel Version(s)
Excel 2016
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...-unique-ids-based-off-multiple-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.

Capture568.PNG

View attachment Excel Guru.xlsx


 
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
 
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.
 
You still have not provided a link to the third forum where you asked the same question. Please do so. Thanks.
 
Back
Top