Forum Discussion
KMorrison5151
Mar 17, 2020Copper Contributor
Cell contains partial text match
I have two columns of data. I would like a fuzzy match from B2 to A2. So if value from b2 is anywhere in a2 that is a match. In attached spreadsheet the result would be No, No, Yes, No, Yes etc. Can anyone suggest the function for that request? Thank you!
DebraAlt The formula should not work at all with the single quotes. Try this:
=COUNTIF(E2:E51,">2")
and make sure that the numbers in E2:E51 are real numbers, Not just texts looking like numbers.
9 Replies
Sort By
- PReaganBronze Contributor
- KMorrison5151Copper Contributor
Many thank yous! Works perfectly.
- PReaganBronze Contributor