Hi,

I have two sets of data with the same columns:

ID, Amount, Number, BillingCompany

I have these in two worksheets within one spreadsheet file, named W
and Sage respectively.

I want to establish differences between the two sets of data, an
establish:

what IDs appear in W2 but not Sage
what IDs appear in Sage but not W2
What IDs appear in both but have different values in the other column
(Amount, number, billingcompany etc.)
For this final criteria, I need to show the data of both records e.g.

ID 1 Amount 100 Number 23 BillingCompany 2
ID 1 Amount 100 Number 22 BillingCompany 2

etc.

but for the first two just the ID is fine.


Can anyone help me out? I have been struggling with this for a whil
now!

Thank

--
DJSTYL
-----------------------------------------------------------------------
DJSTYLi's Profile: http://www.excelforum.com/member.php...fo&userid=1511
View this thread: http://www.excelforum.com/showthread.php?threadid=27829