Nov 18 2021 12:40 PM
Nov 18 2021 01:07 PM
The formula tests A2 against each member of MyList in turn to see whether it is contained within the string A1. The resulting array of counts is summed so that multiple matches within the list are recognised.
Nov 18 2021 01:48 PM
Nov 18 2021 02:04 PM
The formula
= "*"&Mylist&"*"
is an array of text strings, each one preceded and followed by a "*". The "*" is a wildcard that matches any substring so making ""*&in"&"*" a match for "string".
Nov 21 2021 03:52 PM