JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,233
- Office Version
- 365
- Platform
- Windows
Hey All
I'm after a method of comparing two cells and seeing how similar they are, preferably in a percentage format based on the words in the cell.
So;
A1 = "Apples" | B1 = "Apples" - The result would be 100%
A1 = "Apples" | B1 = "Banana" - The result would be 0%
A1 = "Apples Banana" | B1 = "Apples" - The result would be 50%
I'm thinking I might have to go the UDF route, but, thought I'd see if I'd overthought it first LOL
Thanks in advance for any help you can provide
I'm after a method of comparing two cells and seeing how similar they are, preferably in a percentage format based on the words in the cell.
So;
A1 = "Apples" | B1 = "Apples" - The result would be 100%
A1 = "Apples" | B1 = "Banana" - The result would be 0%
A1 = "Apples Banana" | B1 = "Apples" - The result would be 50%
I'm thinking I might have to go the UDF route, but, thought I'd see if I'd overthought it first LOL
Thanks in advance for any help you can provide