Link to home
Start Free TrialLog in
Avatar of ACS2012
ACS2012

asked on

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
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image
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
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image
You could do a few more columns too.  See attached.
test-sheet.xlsx
Avatar of ACS2012
ACS2012

ASKER

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
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image
Here is the file with the formula as stated in my first post.

Zero = not in column A
IP---Copy.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image
Thanks for the grade.  Did that get you what you needed?

Thanks

Steve