Differences between two columns.
 

Does anyone out there know a simpleway to compare the values in two different
columns on an Excel spreadhseet and pick out all of the cells in the first
number that have a value that the second column doesn't have? Thanks.

Say your two columns are A and C (of the same worksheet).

Put this in B1 and drag down to the length of column A:

=isnumber(match(a1,c:c,0))

Apply data|filter|autofilter to column B.

True = there's a match
false = no match

Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm

Mr. Smiley wrote:

Does anyone out there know a simpleway to compare the values in two different
columns on an Excel spreadhseet and pick out all of the cells in the first
number that have a value that the second column doesn't have? Thanks.

--

Dave Peterson

i use the formula =exact() for this.

"Mr. Smiley" wrote:

Does anyone out there know a simpleway to compare the values in two different
columns on an Excel spreadhseet and pick out all of the cells in the first
number that have a value that the second column doesn't have? Thanks.

What if the columns are on different worksheets of the same workbook?

"paige" wrote:

i use the formula =exact() for this.

"Mr. Smiley" wrote:

Does anyone out there know a simpleway to compare the values in two different
columns on an Excel spreadhseet and pick out all of the cells in the first
number that have a value that the second column doesn't have? Thanks.

Does anyone out there know a simpleway to compare the values in two
different columns on an Excel spreadhseet and pick out all of the
cells in the first number that have a value that the second column
doesn't have? Thanks.

One way is to use conditional formatting.

Suppose the first column is A and the second is B.

Select A1 and use
Format Conditional formatting Formula is
Then put for the formula
=COUNTIF(B:B, A1)=0
Then click
Format Patterns
And choose a background color of your choice, followed by clicking OK and
OK again.

Finally, with A1 still selected, click the paintbrush and then spread the
paint down the list of values in column A; this paints the conditional
formatting onto those cells.