Compare 2 columns and output to a 3rd column

[Guest]

Does anyone know how to compare two text columns containing IP addresses and
output the results to a third column or workbook?

 

[Trevor Shuttleworth]

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