Why does this formula cause an error and prevent me from pressing enter? The individual components of the formula seem to work fine, but when combined, they do not function properly.
Here is the string:
.cict oem liab on file exp 11/10/19
This part of the formula is separate:
VSTACK(TRIM(SEQUENCE(10,,0)),{" ";"/";"-"})
Complete formula:
=COUNTIF(VSTACK(TRIM(SEQUENCE(10,,0)),{" ";"/";"-"}), TRIM(MID(A2,SEQUENCE(LEN(A2)),1)))=1
Error:
My Sheet
>Solution :
COUNTIF will not allow the use of Dynamic Array formulas as range inputs. It expects a range.
To get the desired TRUE/FALSE list we use MATCH():
=ISNUMBER(MATCH(TRIM(MID(A2,SEQUENCE(LEN(A2)),1)),VSTACK(SEQUENCE(10,,0),{" ";"/";"-"}),0))
If all you want is the date then use FILTER:
=FILTER(TEXTSPLIT(A2," "),ISNUMBER(--(TEXTSPLIT(A2," "))))
