• Status: Solved
• Priority: Medium
• Security: Public
• Views: 545

# compare two excel columns

How I can compare two excel columns and get the differences between them in a third column??

Column A included 970 lines
Column B included 1289 lines
Some of data are same between them.

Thanks
0
ACS2012
• 3
• 2
1 Solution

Commented:
in column C cell C2 enter =COUNTIF(A:A,B2) and copy down...
this will tell you how many times the value in column B is in columnA
0

IT ConsultancyCommented:
You could do a few more columns too.  See attached.
test-sheet.xlsx
0

Author Commented:
this is not working, I try both solutions

all what I need is to compare column with column ,,,,

I attached the list of IP's which I need to compare,,, column A included less than column B,,,

I need to know what the IP's in column B which they are not in Column A
IP---Copy.xlsx
0

Commented:
Here is the file with the formula as stated in my first post.

Zero = not in column A
IP---Copy.xlsx
0

IT ConsultancyCommented:
I copied my formulae in too.

Column C = TRUE when column B is found in column A
Column D = TRUE when column A is found in column B
Column E = TRUE when it is only found in column A
Column F = TRUE when it is only found in column B

Use the auto filter on column E or F to get a list of those that are in one column or the other.

ALL entries in column A match with column B though
So the list where column F = True are the ones that are "extra" in column B.

But for example 132.22.21.3 appears in column A and B multiple times.

From autofilter, there are some 478 entries in column B that are not in column A.
IP---Copy.xlsx
0

IT ConsultancyCommented:
Thanks for the grade.  Did that get you what you needed?

Thanks

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.