Need to compare two columns of numbers

June 17, 2011 at 05:14:40
Specs: Windows XP
Comparing data in two columns in Excel 2007

I have two lists of numbers, 8400 unique numbers in one column (A), and 10, 500 unique numbers in another column (B). I need to identify the 2100 numbers in column B that are not in the list of numbers in column A.

See More: Need to compare two columns of numbers

Report •

June 17, 2011 at 07:57:37
Highlight the values in Column B

Use Conditional Formatting with this rule, assuming your data starts in B1. Adjust as required.


Whatever values in Column B are not found in Column A will be formatted with the format you chose.

Another option is to place a formula similar to this in Column C and drag it down alongside the data in Column B:

=IF(ISNA(MATCH(B1,A:A,0)),"Value Not In Column A", "")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question