Macro to match identical names and allocate ID's

[Rick Rothstein]

No, you have not "explained", you have simply "said". Look, if these were the numbers...

1001
1002
4001
3001
5001
2001

You said the answer would be 2001. WHY??? And if these were the numbers...

1001
1002
4001
3001
5001

You said the answer would be 1001. WHY???

You have to tell us the logic behind why those are the answers... do not just say they are the answer... tell us why you decided they are the answer. I know you are not just randomly selecting a value from the list of number, but what is not clear to us is why you chose those particular numbers. If you cannot tell us that, then I do not see how anyone will be able to help you (I know I will not be able to without a clear explanation why you select the numbers that you do).

[Excel Fox]

I know I will not be able to without a clear explanation why you select the numbers that you do

That goes for any of the volunteers here. The solution requires a logic, and if you just say that for case X use W and case Y use Z, that is no good, unless there is a clear logic to that.