Penelope,

One way

In C1, add the formula =A1<B1
Copy down the columns

Then do a DataFilterAutofilter, and filter on the value TRUE. This will
show the mis-matches.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PenelopeinCinci" wrote in
message ...
I am trying to compare two columns of data and extract unlike data. I am
familar with VBA code but have seen so many ways to do it. The Help
section
in Excel makes it sound so easy but gives no real direction.