User Profile
SergeiBaklan
Diamond Contributor
Joined 10 years ago
User Widgets
Recent Discussions
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.Re: How to resolve formula discrepancy Excel/SharePoint
We could only make guesses, what exactly happened is not clear. Which version of "offline" Excel, is it Windows or Mac. Which locale is used locally (Portuguese is language added to Office or locale), which regional settings are used with Excel for web and SharePoint (default US or they were changed on another one). Which exactly formula is used in each case. It's given in English, Portuguese one will be =SE(É.ERRO(ÍNDICE(Form1!F:F; LIN()-90)); ""; SE(ÍNDICE(Form1!F:F; LIN()-90) = ""; ""; ÍNDICE(Form1!F:F; LIN()-90)))
