Open pb-0 opened 1 year ago
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: paul@gmail.com --> result: gmail.com A1: paul@outlook.com --> result: paul@outlook.com
Same in COUNTIF
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)))Same in COUNTIF