Hi,
I have a list of parts along with prices some parts repeat (different PO).
I need a formula that calculates average and max for each part.
I have 2 worksheets already with unique part id`s one for average and one for max value.
I used if statement but something is not working.
Please help
Thnx
I have a list of parts along with prices some parts repeat (different PO).
I need a formula that calculates average and max for each part.
I have 2 worksheets already with unique part id`s one for average and one for max value.
I used if statement but something is not working.
Please help
Thnx