Compare 2 columns and output to a 3rd column
 

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

Compare 2 columns and output to a 3rd column
 

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


"jamaican jewel" wrote in message
...
Does anyone know how to compare two text columns containing IP addresses
and
output the results to a third column or workbook?