?
Solved

Excel Comparing Values of 2 Different Files/Worksheets

Posted on 2011-05-06
5
Medium Priority
?
271 Views
Last Modified: 2012-06-27
I have two different Excel spreadsheet/files. I wanted to see if there would be  way to compare the two files to determine the differences between them in values of cells/columns.
0
Comment
Question by:RTM2007
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 35709271
Sure, but it kind of depends on how they are structured.
0
 
LVL 2

Author Comment

by:RTM2007
ID: 35709404
Similar/the same in terms of formatting/values.
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 35709602
Are they data sheets? Or do they have data here an there?

The easiest way would be to open a third sheet and use Exact function to compare all cells fromt he two sheets. But, it really is hard to give any advice without seeing any kind fo a sample.
0
 
LVL 2

Author Comment

by:RTM2007
ID: 35709672
How would use hte EXACT function?
0
 
LVL 29

Accepted Solution

by:
leonstryker earned 2000 total points
ID: 35709746
In cell A1 of the new sheet you woudl enter the following formula

=EXACT([WKB1.xlsx]Sheet1!$A$1,[WKB2.xlsx]Sheet1!$A$1)

If the values of A1 in the 2 sheets youa re comparing are equal, the formula woudl return TRUE, otherwise it would return FALSE.

Leon
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question