Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing and Reconciling 2 excel tables
We regularly receiving inventory update .And it is a huge list.
Question 1 : how do we compare and reconcile the previous inventory xcl table (OldInv)) with the new inventory update xcl table(NewInv) so that we could figure out which sku is new in NewInv and was not present in OldInv? Question 2: how do we compare and reconcile the previous inventory xcl table (OldInv)) with the new inventory update xcl table(NewInv) so that we could point out which sku (columns B) inventory turned to zero in quantity (columns E)? Can it be done? Please share your suggestions. Sincerely, -- capxc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing tables in access | Excel Discussion (Misc queries) | |||
Comparing 2 Tables | Excel Worksheet Functions | |||
Comparing two tables | Excel Discussion (Misc queries) | |||
Comparing tables in excel with formulas | Excel Discussion (Misc queries) | |||
Comparing data in tables | Excel Discussion (Misc queries) |