Excel Sheet Comparison

I need a tool that can compare data between excel sheets regardless of the order.  I have a listing of file names from two seperate computers and I want to compare the two sheets to see what file names are the same and what are different on each computer.  One computer has much more content so the rows do not match up and there are to many line items to do this manually, basically a tool to compare the data and produce a seperate sheet to show what is in one sheet and not the other.
PvteyeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

innovatorengineerCommented:
I am not aware of a tool, but you could change the color of the text in one sheet, copy it to the end of the column of the second sheet, do a sort, then you would see the duplicates and the unique file names coded by color. Not fancy, but gets the job done.
innovatorengineerCommented:
FirstSentinelCommented:
I found this heaven sent tool long ago.

It has saved me TONS of time..

WinMerge

It will compare the content of files and directories.

Once installed there is a plugin called xdocdiff  you can download to compare office documents.

Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

david251Commented:
I would use a vlookup for this.  It is a two phased approach. You need to check the first list against the second and the second against the first

So if your data are in Sheet1!A1:A200 and Sheet2!A1:A250

in sheet1:b1 enter this formula:
=VLOOKUP(A1,Sheet2!$A$1:$A$250,1,FALSE)
Copy this formula to b1:B200


in sheet2:b1 enter this formula:
=VLOOKUP(A1,Sheet1!$A$1:$A$200,1,FALSE)
Copy this formula to b1:B250

If the result =NA then there was no match.  If the formula returns the same text, there is a match.

I hope this helps,
-David251

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DaveCommented:
My Duplicate Master addin
at http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2123-Eliminating-duplicate-data-with-Duplicate-Master-V2.html

Will let you compare/report/highlight duplicates & uniques etc between sheets  

It is more powerful than formula options as it has string functionality to ignore case, remove whitespaces and/or regular expression replacements

Can you post a sample file  ?

Cheers

Dave
DaveCommented:
Suggest that as this is a basic data match that the Asker dis-engaged on that this be closed out

300 points to http:#a34436330.html (straightforward working formula solution)
100 points to http:#a34445615.html (Dup Master addin)
100 points to http:#a34435544.html (link was designed for lists on same worksheet)

Cheers

Dave
Vee_ModCommented:
All,
 
Following an 'Objection' by brettdj (at http://www.experts-exchange.com/Q_26824845.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
Vee_Mod
Community Support Moderator
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.