I have an excel file containing material code, Batch No. quantity manufactured and some other columns with more than 75 rows. One material code may be available in different rows. I want material code wise “subtotal for quantity manufactured” and “total number batches manufactured” against each material code.
Result can be in same sheet or different sheet.
Please help.
Result can be in same sheet or different sheet.
Please help.