Hi Friends,
I spent few hours to findout a solution for my task.
Trying to partial match first 2 or 3 words from ColumnB(B1) data with First 2 or 3 words from ColumnG(G1)
If found the partial match then mark as "Yes", If not, "No".
I do not need to input range like G1:G10 because the correct data will be in the same row.
I did search on forum for related query comparing but did not find one which does exact task.
I have list of data in columnB and ColumnG.
Attached sample file
https://spaces.hightail.com/space/tGOM8TCBfM
I spent few hours to findout a solution for my task.
Trying to partial match first 2 or 3 words from ColumnB(B1) data with First 2 or 3 words from ColumnG(G1)
If found the partial match then mark as "Yes", If not, "No".
I do not need to input range like G1:G10 because the correct data will be in the same row.
I did search on forum for related query comparing but did not find one which does exact task.
I have list of data in columnB and ColumnG.
Attached sample file
https://spaces.hightail.com/space/tGOM8TCBfM