BYROW-ARRAYTOTEXT- FILTER Functions- An Excel Challenge

[@IvanCortinas_ES]

Excellent. A very slight final variation, with the most popular TEXTJOIN... =TEXTJOIN(", ",TRUE,LET( a,BYROW(B2:D18,LAMBDA(x.SUMA(x))), b,A2:A18, FILTRAR(b,a=MAX(a))))

[@Officeinstructor]

Excellent, if you do not have ARRAYTOTEXT then TextJoin is an alternate solution, although a little longer. Thank you for the contribution.

[@unnikrishnansanthosh]

excellent ideas Nabil, thank you for sharing

[@Fxingenieria]

Espectacular !! Excelente!!

[@nadermounir8228]

Thank you Nabil for showing new functions. Great video as always 👍 👌

[@JoseAntonioMorato]

Dear Nabil, Considering E2# as BYROW(B2:D18;LAMBDA(x;SUM(x))): =ARRAYTOTEXT(FILTER(CHOOSE({1,2},A2:A18,E2#),E2#=MAX(E2#))) OR =TEXTJOIN({": ","+","+","=",", "},,FILTER(A2:E18,E2#=MAX(E2#))) 🤗

[@khanabdussabur8604]

Awesome nabil, Thanks a lot.

[@GeertDelmulle]

The BYROW and LAMBDA functions are not yet mainstream which is prohibitive for me to use them because it’s for my colleagues at work I do these kinds of challenges and they don’t have these functions yet. In this case I would use MMULT to avoid this issue and use TEXTJOIN to accomplish the same result. BTW: I think this way of using functions as arguments is too convoluted - it should be as easy/simplified as in Power Query, IMO. Much better than this (e.g. BYROW(range, SUM), by analogy).

[@Officeinstructor]

=TEXTJOIN(" ";;IF(MMULT(B2:D18;{1;1;1})= MAX(MMULT(B2:D18;{1;1;1}));A2:A18;"")) Yes, this is another way of doing things. Thanks for the contribution.

[@brianxyz]

Thankfully, Microsoft listened to you. Eta Lambdas should have been the default from the start.

[@TopBam]

Brilliant!

[@stevereed5776]

These Excel BI challenges are very interesting, I have been looking at these. I've been trying one recently and want to test a list of numbers against the totals of a matrix but the filter function does not accept multiple options in the include argument (as part of the equals), is it possible to include the filter function inside a BYROW function somehow?). Excel Moments does these Excel BI challenges on KZbin and they are always interesting. Any help appreciated

[@ulludacharkha]

The link is not working. It takes to page which is not loading.