# Comparing all the data between two columns

1. ## Comparing all the data between two columns

How do I compare all the fields between two columns and get only the the unique values among them.
I am attaching part of the data.
One column has dates that the second column does not. I have to find out the dates that are not in column 1 and put it in say column C and the dates that are in column B and not in column A put them in column D.
Is there a function which I can use to achieve this result?

2. ## Re: Comparing all the data between two columns

You could use formulas like
In C2: =IF(COUNTIF(B:B,A2)>0,"",A2)
In D2: =IF(COUNTIF(A:A,B2)>0,"",B2)
Then drag them down the column as far as needed.

3. ## Re: Comparing all the data between two columns

What did you try to do in post #2? Looks like the forum can't handle the code.

4. ## Re: Comparing all the data between two columns

Originally Posted by AliGW
What did you try to do in post #2? Looks like the forum can't handle the code.
Fogrot which forum I was posting to. Senility!!

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