Microsoft Excel 2003 (full)

I have two lists of numbers. The first list contains more numbers than the second list.

How can I identify those numbers that are in the second list but not in the first one?Thank you

Brian W

With the data set below, this Conditional Formatting Rule will highlight 1, 55 and 66: =COUNTIF($A$1:$A$8,B1)=0

Select B1:B6 and apply the above Rule via the Conditional Formatting tool.

A B 1 10 1 2 11 12 3 12 55 4 13 16 5 14 66 6 15 17 7 16 8 17

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

Dear DerbyDad03, Thank you for your assistance; it worked perfectly.

Brian W

Ask Your Question

Weekly Poll