Validate the new strings in a column and assign IDs

[Meoth]

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!

[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

[Meoth]

Any help please

[lwolfie]

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