Generating Semi Unique ID's based off Multiple Criteria

**pbsmith82** · 05-26-2019, 10:14 AM

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.

**Pepe Le Mokko** · 05-26-2019, 10:18 AM

Links added as text by OP and under normal form by me

**AliGW** · 05-26-2019, 10:19 AM

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.

**pbsmith82** · 05-26-2019, 10:20 AM

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.

**AliGW** · 05-26-2019, 10:26 AM

On which other site have you cross-posted?

**pbsmith82** · 05-26-2019, 10:27 AM

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 .

**pbsmith82** · 05-26-2019, 10:30 AM

Originally Posted by AliGW

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

**AliGW** · 05-26-2019, 10:36 AM

Thanks.

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

**pbsmith82** · 05-26-2019, 10:43 AM

Originally Posted by AliGW

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

**AliGW** · 05-26-2019, 10:46 AM

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.

**pbsmith82** · 05-26-2019, 10:50 AM

Originally Posted by AliGW

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.

**AliGW** · 05-26-2019, 10:56 AM

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

Generating Semi Unique ID's based off Multiple Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Generating Semi Unique ID's based off Multiple Criteria

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

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Semi complex count formula based on multiple criteria

Getting unique values based on Multiple Criteria

Generating a data summary sheet based on multiple criteria

[SOLVED] Generating Salary Based on Mandays and Multiple Criteria

[SOLVED] Unhide rows based on semi static, semi dynamic value

[SOLVED] Unique value count based on multiple criteria

[SOLVED] Filtering and generating new tabs based on Unique values based in column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions