Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
excel: How can I color code rows based on a value in a cell? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |