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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
bruneta_mara la Simpatie.ro
 | Femeie
24 ani
Ialomita
cauta Barbat
27 - 64 ani |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 892
|
|
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
)
) |
|
|
| pus acum 4 luni |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 892
|
|
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
|
|
| pus acum 2 saptamani |
|