Validate the new strings in a column and assign IDs

Hi,

I have attached the file with columns "Name", "ID" and "Standard Name".

Every month, a user can add new Strings to the column "Name", while doing so, the new string should be checked with the records in column "Name" whether the new string exists or not, case should also be considered.

If the new string seems to be duplicate then assign the ID of the record matched in the column "Name" else assign the Max ID + 1.

As this process occurs every month, would macro work?

Any help is greatly appreciated!

Thanks!

Sample.xlsx

Macros

Accepted answers

All comments

Qiu

@Meoth
Can you also provide your expected output?

If you consider it is a match for "Demolish" and "DEMOLITION", it will be difficult for me. 😁

Meoth

Thanks @Qiu for the reply.

Please see attached output sample. Oh Yes there is a match for Demolish and Demolition

Thanks again

Output.PNG

Meoth

Any help please

lwolfie

Not sure if you solved this, but here's one solution.

String Validation.yxzp

dreldrel

Try to add a timestamp with the running date at the end. This would help you validate your name or IDs. If this helps, please like the comment

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703