software

Hello! I have 2 spreadsheets of data (they are lists of attorneys with their
name, phone, address etc..) and I want to check to see if they have the same
information, or if one is diferent from the other and what fields, if any,
are different. Is there an easy way to accomplish this? Thanks for any help
you can provide.


Hi,
The easiest amp; quickest way I know for doing a quot;one offquot; check (if the
sheets are small or expected to be very similar eg both sorted
alphabetically etc) is to insert a new spreadsheet in the file (or in
one of the files if the 2 sheets are in separate files) that the 2
sheets are in.

In cell A1 of the new sheet type quot;=quot; and then select cell A1 of one of
the 2 existing sheets with the mouse, type quot;=quot; again, select cell A1 of
the other existing sheet with the mouse amp; press [enter]. This will
result in a formula similar to below:

='Other Sheet'!B55='Original Sheet'!A1

and will result in either quot;TRUEquot; if they are the same or quot;FALSEquot; if
they are different. Copy cell A1 down as many rows amp; across as many
columns as needed to cover all the data amp; then use Find to search for
the quot;falsequot; values.

If the sheets are expected to be quite different or may have had rows
inserted the above technique is not very helpful. In that case check
out the bottom of Chip's page below which describes how to quot;Extract
Values On One List And Not Anotherquot;:

www.cpearson.com/excel/duplicat.htmhth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=521292ok. Thanks. I'll check it out.

quot;broro183quot; wrote:

gt;
gt; Hi,
gt; The easiest amp; quickest way I know for doing a quot;one offquot; check (if the
gt; sheets are small or expected to be very similar eg both sorted
gt; alphabetically etc) is to insert a new spreadsheet in the file (or in
gt; one of the files if the 2 sheets are in separate files) that the 2
gt; sheets are in.
gt;
gt; In cell A1 of the new sheet type quot;=quot; and then select cell A1 of one of
gt; the 2 existing sheets with the mouse, type quot;=quot; again, select cell A1 of
gt; the other existing sheet with the mouse amp; press [enter]. This will
gt; result in a formula similar to below:
gt;
gt; ='Other Sheet'!B55='Original Sheet'!A1
gt;
gt; and will result in either quot;TRUEquot; if they are the same or quot;FALSEquot; if
gt; they are different. Copy cell A1 down as many rows amp; across as many
gt; columns as needed to cover all the data amp; then use Find to search for
gt; the quot;falsequot; values.
gt;
gt; If the sheets are expected to be quite different or may have had rows
gt; inserted the above technique is not very helpful. In that case check
gt; out the bottom of Chip's page below which describes how to quot;Extract
gt; Values On One List And Not Anotherquot;:
gt;
gt; www.cpearson.com/excel/duplicat.htm
gt;
gt;
gt; hth
gt; Rob Brockett
gt; NZ
gt; Always learning amp; the best way to learn is to experience...
gt;
gt;
gt; --
gt; broro183
gt; ------------------------------------------------------------------------
gt; broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
gt; View this thread: www.excelforum.com/showthread...hreadid=521292
gt;
gt;

Go to Google, type Excel compare. You might see some sites like the one
below. Sometimes you have to pay for what you want.
www.florencesoft.com/

HTH

Gilles
quot;iuwonnyquot; gt; wrote in message
...
gt; Hello! I have 2 spreadsheets of data (they are lists of attorneys with
gt; their
gt; name, phone, address etc..) and I want to check to see if they have the
gt; same
gt; information, or if one is diferent from the other and what fields, if any,
gt; are different. Is there an easy way to accomplish this? Thanks for any
gt; help
gt; you can provide.
I use Jim Cone's fine commercial Add-in for things like this. It's
available at

www.realezsites.com/bus/primi...ware/index.php

Vaya con Dios,
Chuck, CABGx3quot;iuwonnyquot; gt; wrote in message
...
gt; Hello! I have 2 spreadsheets of data (they are lists of attorneys with
their
gt; name, phone, address etc..) and I want to check to see if they have the
same
gt; information, or if one is diferent from the other and what fields, if any,
gt; are different. Is there an easy way to accomplish this? Thanks for any
help
gt; you can provide.