Compare two different excel files to know the price differences.
File 1 is Master data (2000 rows)
File 2 is price from plant A (800 rows)
File 1 Column A is item number, column B is standard cost.
File 2 Column A is part number, column B is unit cost.
Note: Item number is different in two sheets. Need to clean and process the common data.
Simply Compare the standard price or cost with the corresponding parts and provide a short analysis (bar chart or pivot table or pie chart as per your choice).
Keep the data in changable format so that if price changes the analysis should automatically change.
Please provide a draft copy of the work before submitting the final work.
Prefer early members who can deliver the work within next 12 hours.
Please feel free to ask any question.