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:
carmenitza din Ialomita
 | Femeie
24 ani
Ialomita
cauta Barbat
24 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
Source:
https://superuser.com/questions/301701/ ... t-in-value
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.
|
|
| |
|
