Using BYCOL()
and TEXTSPLI0T()
(and AND()
):
=BYCOL(TEXTSPLIT(A7,","),
LAMBDA(a,
AND(
ISNUMBER(VALUE(CONCAT((FIND(MID(a,1,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")),(FIND(MID(a,2,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))))),
ISNUMBER(VALUE(MID(a,3,8))),
LEN(a)=10)))
This will output an array, if you wrap an AND()
around it, it will output just TRUE
or FALSE
.
Note, I TEXTJOIN()
-ed the list from A1:A5 in cell A7, with ", "
.
Sample 2 to show FALSE
output.
(Excel in different language, WAAR
= TRUE
, ONWAAR
= FALSE
)
Also note: this doesn't exclude duplicates:
Cell highlight manually done