<div>
Sure, but it kind of depends on how they are structured.
</div>


Sure, but it kind of depends on how they are structured.

<div>
Similar/the same in terms of formatting/values.
</div>


Similar/the same in terms of formatting/values.

<div>
Are they data sheets? Or do they have data here an there?<br />
<br />
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.
</div>


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.

<div>
How would use hte EXACT function?
</div>


<div>
<div class="content wysiwyg-content">
I have two different Excel spreadsheet/files. I wanted to see if there would be &nbsp;way to compare the two files to determine the differences between them in values of cells/columns.
</div>
</div>


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.

Excel Comparing Values of 2 Different Files/Worksheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.