Hello,
Im looking for a vba or function for similar matching script.
They will match based on characters, letters, numbers in a list for more options in the same list. It is not an exact match but there a more options in the list with same letters, structure.
IF find then give them an Reference ID for all these options.
See example
Is it possible?
See: https://www.microsoft.com/en-gb/down....aspx?id=15011
Courtesy of alansidman.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try this Macro code. It compares first 3 words only.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks