Solved

# Excel Comparing Values of 2 Different Files/Worksheets

Posted on 2011-05-06
Medium Priority
271 Views
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
Question by:RTM2007
• 3
• 2

LVL 29

Expert Comment

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

LVL 2

Author Comment

ID: 35709404
Similar/the same in terms of formatting/values.
0

LVL 29

Expert Comment

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

ID: 35709672
How would use hte EXACT function?
0

LVL 29

Accepted Solution

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

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…
###### Suggested Courses
Course of the Month17 days, 5 hours left to enroll

#### 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.