Comprare two

[aayushagra]

Okay so i have two rows of text(both about 400 cells)



And i need to know which of them dont come together(They are alphanumeric)

so for example

A B
1212x1d21dc 321fc12c23c
12345zxcvb asfsafd4rtt323
321fc12c23c 12345zxcvb
asfsafd4rtt323 1890cu990u

Now here 1212x1d21dc, 321fc12c23c, 1890cu990u, 321fc12c23c dont appear twice, the rest do.
I want to know which of them appear in a odd amount, and which dont. Any way to sort them?

[macropod]

Hi aayushagra,

Assuming your data are in columns A & B, you can use the following formula in C1 and copy down as far as needed:
=COUNTIF(A:A,B1)
This will tell you which values in column B also appear in column A, and how often.

Similarly, if you use the following formula in D1 and copy down as far as needed:
=COUNTIF(B:B,A1)
it will tell you which values in column A also appear in column B, and how often.

If you then convert the formulae to values, you can then sort the data by column C or D.