User Profile
SergeiBaklan
Diamond Contributor
Joined 10 years ago
User Widgets
Recent Discussions
Re: I need to learn how to use the LET function in Excel...
IMHO, it all depends on concrete case. Most important points to consider are maintenance and performance. From maintenance point of view LET(), IFS(), SWITCH() and their combinations are more preferrable. But if performance is critical when nested IF is better choice.Re: REGEX+TEXTSPLIT
If without regex we may use RepSplit=LAMBDA(txt, LET( sep, "|", engine, LAMBDA(fn,str, IF(LEN(str) <= 1, str, LET( h, LEFT(str), t, RIGHT(str, LEN(str) - 1), h & IF(h=LEFT(t), sep, "") & fn(fn,t) )) ), rs, LAMBDA(str, engine(engine, str)), TEXTSPLIT( rs(txt), sep ) ) ); With Regex we may use peiyezhu pattern inside Excel =TEXTSPLIT(REGEXREPLACE(A2, "(.)(?=\1)", "\1|"), "|") Results areRe: Excel (365 & 2016) with network information...and much more Information to Filter.
Hi NikolinoDE , This one shows everything. One more comment. After "All tests" run we have Actually we stay on Results sheet, but that's only you who knows that. If you disabled sheets navigation please don't mention sheet names in messages.
