Match the text between 2 range and highlight

[shantraj.antin@gmail.com]

Hi Team,

I have a set of Description in range B2 to B55 and every time I copy paste few statements in F and try to highlight even if one word is matching with the rage items B2 to B55.

For example : in B4 description is "CANCELLATION AND NONRENEWAL ENDORSEMENT " and word Cancellation matches with statements mentioned F2: "Cancellation is not accepted"


Prepositions like "To", "of", "for", "at" should be ignored while matching

Statements in F2 changes every time but description in B2 to B55 remains same.

Kindly help me to make this process faster.

Thank you.

 

[Nebu]

Hi:

Download this add-in to get the desired results

https://www.microsoft.com/en-au/download/details.aspx?id=15011

Thanks

 

[shantraj.antin@gmail.com]

Hi Nebu,

Thanks for your response.

There is a problem, in my office laptop i cannot install the add in.

can you please help me excel formula or macro

Thank you

 

[Nebu]

Hi:

Here is a link which have vba codes for fuzzy logic
http://www.access-programmers.co.uk/forums/showthread.php?t=270126

Thanks