Excel BI Challenge Workout 186

Workouts Excel BI Challenge
21

LinkedIn Post by:
Kris Jaganah

=MAP(A2:A7,LAMBDA(k,LET(a,--TEXTSPLIT(k,,", "),b,MOD(a,2),c,MAP(b,LAMBDA(x,SUM(--(x=b)))),IF(MIN(c)=MAX(c),"",ARRAYTOTEXT(FILTER(a,SMALL(c,1)=c))))))

22

LinkedIn Post by:
Miguel Angel Franco García

Envío de mi soluccion

=UNIRCADENAS(","; VERDADERO; LET(a;ORDENAR(ENCOL(ABS(DIVIDIRTEXTO(A2;","))));b;SI(BYROW(a; LAMBDA(c;ES. IMPAR(c)))=VERDADERO;a;""); d;SI(BYROW(a; LAMBDA(e;ES. PAR(e)))=VERDADERO;a;""); SI(SUMA(b)<SUMA(d);b;d)))

23

LinkedIn Post by:
Oscar Mendez Roca Farell

hi everyone, my proposal solution:

=MAP(A2:A7, LAMBDA(a, LET(_n,--TEXTSPLIT(a,", "),_m, MOD(_n,2),_c, SUM(_m)/COUNT(_n), TEXTJOIN(", ",1, IFERROR(FILTER(_n,_m=(_c<0,5)/(_c<>0,5)),"")))))

24

LinkedIn Post by:
Bo Rydobon
 

=MAP(A2:A7,LAMBDA(a,LET(t,TEXTSPLIT(a,,", "),o,FILTER(t,ISEVEN(t),""),e,FILTER(t,ISODD(t),""),
ARRAYTOTEXT(SWITCH(SIGN(ROWS(o)-ROWS(e)),0,"",1,e,o)))))
25

LinkedIn post by:
Rick Rothstein

=MAP(A2:A7,LAMBDA(a,LET(n,TEXTSPLIT(a,", "),e,MOD(n,2)=0,o,MOD(n,2),so,SUM(o),se,SUM(0+e),IFERROR(TEXTJOIN(", ",,IF(so>se,FILTER(n,e),IF(se>so,FILTER(n,o),""))),""))))

26

LinkedIn Post by:
Nicolas Micot
 

=LET(_nombres;FRACTIONNER.TEXTE(A2;",")+0;
_pair;FILTRE(_nombres;MOD(_nombres;2)=0);
_impair;FILTRE(_nombres;MOD(_nombres;2)>0);
JOINDRE.TEXTE(", ";VRAI;SI(NBVAL(_pair)<NBVAL(_impair);_pair;SI(NBVAL(_impair)<NBVAL(_pair);_impair;""))))
27

LinkedIn Post by:
Sunny Baggu
 

=MAP(
 A2:A7,
 LAMBDA(x,
 LET(
 _split, TEXTSPLIT(x, , ", ") + 0,
 _odd, FILTER(_split, ISODD(_split), ""),
 _oddnum, ROWS(_odd),
 _even, FILTER(_split, ISEVEN(_split), ""),
 _evennum, ROWS(_even),
 IFNA(
 ARRAYTOTEXT(IFS(_oddnum < _evennum, _odd, _oddnum > _evennum, _even)),
 ""
 )
 )
 )
)
28

LinkedIn Post by:
Amardeep Singh
 

=BYROW(A2:A7,LAMBDA(r,
ARRAYTOTEXT(LET(d,--TEXTSPLIT(r,", "),od,SUM(--ISODD(d)),ev,SUM(--ISEVEN(d)),IFS(od=ev,"",od<ev,FILTER(d,ISODD(d)),TRUE,FILTER(d,ISEVEN(d)))))))
29

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

=MAP(A2:A7,LAMBDA(a,LET(
e,TEXTSPLIT(a,,", "),
v,--ISODD(e),
n,SUM(v),
r,ROWS(e)-n,
TEXTJOIN(", ",,IFS(r<n,IF(v,"",e),r>n,IF(v,e,""),1,"")))))