Will Excel "compare" two worksheets or files?

[George]

I'm using MSExcel2003, SP2....

I already read about the technique where you can put two MSExcel
spreadsheets side-by-side and *visually* compare...which is a very "manual"
technique, but...

Will MSExcel "compare" two worksheets and highlight differences for the user
(like you can do in MSWord...where the resulting output highlights
differences in red...great to for comparing differences in different
versions of some text document)?

If not, is there a software app (preferably in WinXP) that would at least
give a "yes" or "no" on whether two files are identical (duplicates?)

Thanks,
George

 

[mrice]

This isn't exactly what you are looking for but it might help.

You could use the EXACT formula in a range of cells identical to those
used in the two spreadsheets. Any occurences of false would indicate a
difference.

You could also try a macro which selected the set of occupied cells in
one of the sheets and compared one by one to the other.

 

[Paul B]

George, take a look at Compare.xla, it is an add-in, written by Myrna
Larson and Bill Manville, it will compare the contents of two worksheets or
workbooks.
You can download it at Chip Pearson's site here
http://www.cpearson.com/excel/whatsnew.htm about half way down the page


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[keepITcool]

George,

try the addin Synkronizer. It may be what you are looking for.
30 days trial can be downloaded from www.synkronizer.com

 

[DiffEngineX]

DiffEngineX is the best way to compare either two worksheets or two whole Excel workbooks.

You can run DiffEngineX from its user interface or from the Windows command prompt.

If you run it from software or the command prompt, it will return a value saying whether two workbooks are identical or not.

See

http://www.florencesoft.com/compare...hen-calling-diffenginex-programmatically.html

for details.

For the free trial download go to

http://www.florencesoft.com/excel-differences-download.html