Please ignore this post

Thanks @Tim..

Article is very useful....

Good Evening.....

Thanks @Maxim......

I just ran your solution and it gave the required result..!!

Though I thought I should also develop code on my own.

Can you comment on the code written by...

Here search terms are changing dynamically. Also search term values are from two different columns and are searched alternatively (First from column A then B then again A and so...

Sorry for any inconvenience. Thanks for correcting me.

I have reformulated the logic....please refer first edited post.

I am not expert in queries as of now.

Can you give some inputs so I go go ahead.

thanks