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.