Compare 2 columns and output to a 3rd column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to compare two text columns containing IP addresses and
output the results to a third column or workbook?
 
Assuming your IP addresses are in columns A and B starting in Row 2:

Put the following formula in cell C2 (for example)

=IF(COUNTIF(B:B,A2)>0,A2 & " in column B",A2 & " not in column B")

And put the following formula in cell D2 (for example)

=IF(COUNTIF(A:A,B2)>0,B2 & " in column A",B2 & " not in column A")

Use Fill Down or just drag down the column.

Switch on AutoFilter and filter on contains "not" or does not contain "not"
to highlight whichever you want to see.

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
VBAscript for data matching excels 0
compare and move numbers 5
Help with LEFT function 5
VBA Excel partial cell compare to another cell 0
Filtering Data in Columns 3
comparing 2 columns 6
Exact Function 1

Back
Top