Comparing words in sentences by percentage

[AmazingTrans]

Hi there.

I am using google sheet currently to compare two column of with many rows of strings.
I would like to compare such that if column A = Column B is closely match up to > 50% of the word, return true.
For example:

- This is a car and it is blue
- This a car and it is blue

This would return be true.

Does anyone know how this could possibly be done?

[Richard Buttrey]

Hi,

Don't know about Google Sheets, but if you were doing this with Excel, for a fuzzy match process like this you'd be better advised to download and Micrsofte's Excel's Fuzzy Lookup Add-In. See here...

https://www.microsoft.com/en-gb/down....aspx?id=15011