View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mortir Mortir is offline
external usenet poster
 
Posts: 34
Default matching/comparing lists

I have the following two lists:

LIST 1
Product Date Quantity
A 11 Nov 2007 130
B 13 Nov 2007 150
C 15 Nov 2007 200
C 17 Nov 2007 250
B 19 Nov 2007 240

LIST 2
A 11 Nov 2007 130
B 13 Nov 2007 150
D 14 Nov 2007 1000
C 15 Nov 2007 200
D 16 Nov 2007 1000
C 17 Nov 2007 250
B 19 Nov 2007 240


List 2 is the same as list 1 except that it has two new inputs -
product D on 14th and 16th Nov, with the same quantities of 1000. How
could I compare the two lists so that I could easily identify the
changes that were made to the first list? Or to identify the new
inputs that were made...

thanks for your help