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)
ENTERPRISE PROJECT B: (Composed of Two different Products)
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.
View attachment Excel Guru.xlsx
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.
View attachment Excel Guru.xlsx