Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two columns and finding matching names | Excel Worksheet Functions | |||
Comparing two lists | Excel Discussion (Misc queries) | |||
comparing lists - i think | Excel Discussion (Misc queries) | |||
comparing lists | Excel Discussion (Misc queries) | |||
Comparing Lists | Excel Worksheet Functions |