Solved Finding Unique Numbers in an Excel 2010 SS

Microsoft Excel 2003 (full)
October 11, 2011 at 15:32:45
Specs: Windows XP, 1.0Gb
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


See More: Finding Unique Numbers in an Excel 2010 SS

Report •


#1
October 11, 2011 at 17:31:58
✔ Best Answer
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.


Report •

#2
October 12, 2011 at 05:02:37
Dear DerbyDad03,

Thank you for your assistance; it worked perfectly.

Brian W


Report •

Related Solutions


Ask Question