Comparing 2 excel files

A

AB@

Hi, I am a newbie here in the group.
I must compare a lot of similar excel files, but the normal sw of
comparing don't help me.
It's because there's a lot of line addings in the "second" file of the
compare.

I wanna to know if there's some sw that do this, with "intelligence"
as the "WinMerge" do in the normal text file.

Previously thanks to all
AB@
 
J

Jim Cone

Excel 2003 has a Compare Side by Side feature that allows
you to make a visual comparison between two sheets.
The menu item is on the Windows menu.

The commercial Excel add-in "XL Companion" from yours truly
can make a "row" comparison between two sheets and
provide a listing of mismatched (uncommon) rows.

It can also compare (cell by cell) two selections or two entire worksheets.
Providing a listing of common and uncommon items between two single
column lists is another feature.
It will also find and list the rows, on a single sheet, that contain specified items.
And there is more.
A free trial is available from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"AB@" <[email protected]>
wrote in message
Hi, I am a newbie here in the group.
I must compare a lot of similar excel files, but the normal sw of
comparing don't help me.
It's because there's a lot of line addings in the "second" file of the
compare.

I wanna to know if there's some sw that do this, with "intelligence"
as the "WinMerge" do in the normal text file.

Previously thanks to all
AB@
 
A

AB@

You can check my CompareIt fromhttp://www.grigsoft.com/- it can
convert xls to text internally.

Igor Greenhttp://www.grigsoft.com/
Compare It! + Synchronize It! - files and folders comparison never was
easier!

Thanks, it's good and it's more powerful than some others programs I
have tried, but it's not the best for my needs, because I have some
records that have only a field that's different, and so it says me
that all the row is different, and i must go see the differences...

Thanks anyway
AB@
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top