I am creating a spreadsheet to track backlogged orders for service parts.
Column E is the Days, Column F is Qty, and Column G is part number.
I would like to have Column B be the MAX of Column E, Column C be the AVERAGE of Column E and Column D be the SUM of Column F.
Here is where it gets tricky, the report I receive lists each order as a separate line. I need to aggregate the lines so one line represents each part.
So the report might be 3000 lines total, but a part number (Column G) could be on 500 lines, or 5 lines.
I need to write a code that will MAX, AVERAGE and SUM based on the part number and have only one line for each part number.
Column E is the Days, Column F is Qty, and Column G is part number.
I would like to have Column B be the MAX of Column E, Column C be the AVERAGE of Column E and Column D be the SUM of Column F.
Here is where it gets tricky, the report I receive lists each order as a separate line. I need to aggregate the lines so one line represents each part.
So the report might be 3000 lines total, but a part number (Column G) could be on 500 lines, or 5 lines.
I need to write a code that will MAX, AVERAGE and SUM based on the part number and have only one line for each part number.