Forum Discussion
PeterBartholomew1
Nov 12, 2022Silver Contributor
FIFA World Cup 2022. A demonstration of Lambda functions.
2022 FIFA World Cup Qatar Free Predictor Template For Excel (spreadsheet1.com) Again, this year I worked with Petros to produce an update for the 2022 FIFA World Cup. The striking thing was that so...
PeterBartholomew1
Nov 15, 2022Silver Contributor
I don't think MUNIT is ever likely to achieve "Most Valuable Function" status!
I suppose one could always define
DiagSplitλ
= LAMBDA(w,
LET(
n, LEN(w),
k, SEQUENCE(n),
letter, MID(w,k,1),
diag, MUNIT(n),
IF(diag,letter,"")
)
)
= DiagSplitλ(word)Patrick2788
Nov 15, 2022Silver Contributor
Diagonals may be more trouble than it's worth, now that I look at MUNIT again. It seems I'd probably go the familiar route of text manipulating: joining, splitting, wrapping, etc.