How do I write a VBA code in excel that will compare two columns .
 

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.

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.

not a code answer but check out
http://www.cpearson.com/excel/duplicat.htm

for lots of ideas on dealing with duplicates

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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.