fast-formula-parser
fast-formula-parser copied to clipboard
LesterLyu
SEARCH and COUNTIF array criteria breaking
SEARCH and COUNTIF seem not to support arrays in criteria argument. For both functions, only the first element is evaluated.
For example, SEARCH evaluates "outlook.com" but not "gmail.com":
IF(SUMPRODUCT( -- ISNUMBER(SEARCH({"outlook.com", "gmail.com"},A1)))>0,A1,RIGHT(A1,LEN(A1)-FIND("@",A1)))
A1: [email protected]
--> result: gmail.com
A1: [email protected]
--> result: [email protected]
Same in COUNTIF
