Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "C". Type in "B3": "= IF (A3 <> $table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down. Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "C". "B". Type in "B3": "= IF (A3 <>$ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.
Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= IF (A3 WENN(A3 <> $table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. displayed. WENN is in english IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down. Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <>$ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. WENN is in english english-UI IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.
Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <> $table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. WENN is in english-UI IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down. WENN is in english-UI IF. Tabelle is table. Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <>$ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.