Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Pivot Table Data
I have 2 different pivot tables & want to merge them to get differences in
quantities of identical part numbers. For example :- Table 1 - In Stock Table 2 - Required Part Nr Qty Part Nr Qty 12 2 10 2 15 1 12 4 16 3 13 4 20 1 20 1 26 5 23 2 28 4 35 1 I want to get the difference between the two tables as if Table 1 were parts in stock & Table 2 parts required and for the results only to show for the parts in table 2 Output as below if possible Part Nr Deficit 10 -2 12 -2 13 -4 20 0 23 -2 Is this possible? Kenny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Merging data into pivot tables | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Merging Workbook Table data Based upon Value comparisons | New Users to Excel | |||
Merging Pivot Table Data | Excel Discussion (Misc queries) |