Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
geogeorgiana17 pe Simpatie
 | Femeie
25 ani
Arad
cauta Barbat
26 - 57 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
Lambda to add to Name Manager:
=LAMBDA(range; [separator];
LET(
sep; IF(ISOMITTED(separator); ""; separator);
rowConcat; BYROW(range; LAMBDA(r; TEXTJOIN(sep; TRUE; r)));
nonBlank; FILTER(rowConcat; rowConcat <> "");
nonBlank
)
) |
|
|
| |
|
| #2 |
TRaPModerator
Postari: 960
|
|
More arguments to be able to also return to 1 cell instead of a spilled range, and adds the possibility to also add an endSeparator
=LAMBDA(range;[separator];[ignoreEmpty];[toCell];[cellSeparator];[endSeparator];
LET(
sep; IF(ISOMITTED(separator); ""; separator);
ign; IF(ISOMITTED(ignoreEmpty); TRUE; ignoreEmpty);
oneCell; IF(ISOMITTED(toCell); FALSE; toCell);
cellSep; IF(ISOMITTED(cellSeparator); ""; cellSeparator);
endSep; IF(ISOMITTED(endSeparator); ""; endSeparator);
rowConcat;
BYROW(range; LAMBDA(r; TEXTJOIN(sep; TRUE; r)));
cleaned;
IF(ign; FILTER(rowConcat; rowConcat <> ""); rowConcat);
result;
IF(
oneCell;
TEXTJOIN(cellSep; TRUE; cleaned);
cleaned
);
IF(
endSep = "";
result;
IF(
oneCell;
result & endSep;
result & endSep
)
)
)
) |
Source: ChatGPT
|
|
| |
|
