Hello there,
I really hope you can help me with my little problem.
I have two tables with some data in it. It looks like this:
Table 1:
Table 2:
I would like to have a formular to compare these tables. But it should only compare those indicator which are in table a and table b. In this example it should ignore indicator 4 and 5.
Further I would like to get the number of those indicators with different values in table a compared to table b.
I really hope you can help me.
Greetings,
Manú
I really hope you can help me with my little problem.
I have two tables with some data in it. It looks like this:
Table 1:
| indicator | value1 | value2 |
| 1 | 1 | 3 |
| 2 | 1 | 3 |
| 3 | 1 | 3 |
| 4 | 1 | - |
Table 2:
| indicator | value1 | value2 |
| 1 | 1 | 1 |
| 2 | 1 | 3 |
| 3 | 1 | 3 |
| 5 | 1 | 3 |
I would like to have a formular to compare these tables. But it should only compare those indicator which are in table a and table b. In this example it should ignore indicator 4 and 5.
Further I would like to get the number of those indicators with different values in table a compared to table b.
I really hope you can help me.
Greetings,
Manú
