compare two worksheets and identity data that is not present in both
My goal is to compare two worksheets and identity data that is not present in both and label each record as such. Essentially, I need to compare transaction numbers from a column of data in worksheet A against a column of data in worksheet B and identify which records are not present in worksheet B.
Can anyone suggest a solution?
Last edited by samchargers09; 08-31-2010 at 02:33 PM. Reason: solved
Something like this in one of the workbooks, in an empty column:
=ISNUMBER(MATCH(A1, '[Book2.xlsx]Summary'!$A:$A, 0))
The result will be TRUE/FALSE. Copy that down once you get a correct answer for the first row. You may have to tweak a little on the sheetname and workbook name, but this is the syntax.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Worked great. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks