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:
Profil Sabina
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 63 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2308
|
|
This is case insensitive. Displays TRUE or FALSE if cells in range have any letters A-Z.
Works well with Conditional Formatting.
USAGE:
LAMBDA to add to Name Manager:
=LAMBDA(rng;
BYROW(rng;
LAMBDA(row;
SUMPRODUCT(--ISNUMBER(SEARCH(
{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"};
row)))>0
)
)
) |
_______________________________________
|
|
| pus acum 3 ore |
|