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:
bruneta99
 | Femeie
25 ani
Satu Mare
cauta Barbat
25 - 50 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
In my example, I have 2 columns with formulas in Sheet1:
- column 1 (A) has vlookup to check something in several columns, including column 2
- column 2 (B) is equal to a column in another sheet (simple formula =Sheet2!E3)
If I delete some rows in Sheet2, the values in column 2 remain the same, so I must update them. The formula should prevent me from forgetting to do that.
I don't want to have more formulas in another column to tell me if A2 = B2;"1";"0" and drag this on the entire column and then set a formula to tell me if a value in C2:C1000 is 0 then return FALSE. Too much hassle.
I just want to have a color formatted cell to tell me if column A and B are equivalent, TRUE, otherwise display error.
This can be done using an ARRAY formula:
=AND(A2:A11=B2:B11)
and to enter the formula press CTRL+SHIFT+ENTER
it should look like this: {=AND(A2:A11=B2:B11)}
If the columns are equivalent, the returned value will be TRUE, otherwise it will be #REF.
|
|
| pus acum 6 ani |
|