mtahreemalam
New Member
- Joined
- Nov 18, 2019
- Messages
- 28
Since you are trying to match "WORDS" I think the previous suggestions will fail since they will match any substring rather than whole words.
You're welcome. Glad to help.Thankyou for all and Peter. That was exactly the problem i was facing!
Thankyou so much Dante once again!Hi @mtahreemalam, With the characteristic mentioned by Peter, then my formula would look like this:
=SUM(--ISNUMBER(SEARCH(" "&$B$1:$B$400&" "," "&A2&" ")))