Excel BI Challenge Workout 187

Workouts Excel BI Challenge
21

LinkedIn post by:
[

Oscar Mendez Roca Farell

](https://www.linkedin.com/in/ACoAAA6zDE4Bt5G7qmkAGrxIvbPLBBRDss3L4Gk)

hi everyone, my proposal solution:

=TOCOL(MAP(A2:A9, LAMBDA(n, IF( SUM( CODE( TAKE( MID( TEXTSPLIT(LOWER(n)&" "," "), SEQUENCE( LEN(n)/2), 1), , 2))*{1\-1})=0, n, n+1))), 3)

22

LinkedIn Post by:
محمد حلمي
 

=FILTER(A2:A9,MAP(A2:A9,LAMBDA(a,LET(
v,TEXTSPLIT(a,," "),
n,SEQUENCE(20),
IFERROR(AND(SORT(MID(TAKE(v,1),n,1))=
SORT(MID(DROP(v,1),n,1))),)))))
23

LinkedIn post by:
Taeyong Shin

=TOCOL(IF(MAP(A2:A9, LAMBDA(m, LET(t, TEXTSPLIT(m, " "), c, MID(t, SEQUENCE(MAX(LEN(t))), 1), AND(XMATCH(TAKE(c, , 1), DROP(c, , 1)))))), A2:A9), 2)

24

LinkedIn post by:
Kris Jaganah
 

=FILTER(A2:A9,MAP(A2:A9,LAMBDA(v,LET(b,DROP(REDUCE("",TEXTSPLIT(v," "),LAMBDA(x,y,HSTACK(x,MID(y,SEQUENCE(LEN(y)),1)))),,1),IFERROR(IF(FIND(" ",v)>0,MIN(--(SORT(TAKE(b,,1))=SORT(TAKE(b,,-1)))),0),0)))))