Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare 6 columns of text data | Excel Worksheet Functions | |||
Is it possible to merge columns for HMTL output? | Excel Discussion (Misc queries) | |||
Automatically Sort By Reference Amount? | Excel Worksheet Functions | |||
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
How can I sort SSNs in Terminal Digit Order using Excel? | Excel Worksheet Functions |