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:
Gabriela Gaby pe Simpatie.ro
 | Femeie
25 ani
Suceava
cauta Barbat
26 - 71 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
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
)
)
) |
_______________________________________
|
|
| |
|
