# How Compare two tables, and result ( only the differences )

1. ## How Compare two tables, and result ( only the differences )

Good Morning

I have a problem ,, with two tables (A, B ) which contains two column information each,,
and i need to compare them and keep only with the information that is not similar.

For exemple

Table 1 | Table 2
---------------------------------
A 1 | A 1
B 2 | D 4
C 3 | E 5
D 4 |
E 5 |
F 6 |

Result ( only the differences )
---------------------------------
B 2
C 3
F 6

How could I do ? Knowing the actual situation ,
the number of lines is greater than a thousand events?

Thank U

3. ## Re: How Compare two tables, and result ( only the differences )

Hi, thanks for the fast asnwer

i think it“s ok,, but i have two quest for the conclusion:

a) Where i change in the formula my cells in the real situation here;
b) If, some values of the 2 columm are no equal like so
Table 1
A - 1
Table 2
A - 2
what is the behavior of the solve above?

4. ## Re: How Compare two tables, and result ( only the differences )

Hope this helps:

RED - Main range
GREEN - Compare range (Extend it so it get more than 10 values. I.e. \$D\$1:\$D\$100
ORANGE - Start range. One cell above first value

Formula:
`Please Login or Register  to view this content.`

Confirmed with ctrl+shift+enter (not just enter)

5. ## Re: How Compare two tables, and result ( only the differences )

find the formula entered in the row c. finally sort the row C.

There are currently 1 users browsing this thread. (0 members and 1 guests)