User Profile
SergeiBaklan
Diamond Contributor
Joined 10 years ago
User Widgets
Recent Discussions
- 26Views1like1Comment
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.17Views0likes0CommentsRe: 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 are17Views0likes0CommentsRe: POWER QUERY NOT WORKING !!
That's repeating of 2 weeks ago discussion Power Query Error Data Not Loading | Microsoft Community Hub Interesting, Excel gave the same error 20 years ago, long before PQ appeared. Excel was unable to load a necessary component Maybe something else, not PQ?27Views0likes0Comments- 14Views1like0Comments
Re: 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.53Views0likes2Comments
Recent Blog Articles
No content to show