Thread: Find and calculate average

Hello,

I would like to write a simple formula that would find each of the products in column A and calculate the average score.

I've attached the excel file for your reference.

Thanks!

Originally Posted by oldchippy

Hi,

May be a PIVOT Table would help?

Yes, a pivot table would help, but I am trying to automate the process on a large scale so that I don't have create pivot tables for multiple sheets. I have simplified the data so that I can recieve insight into a formula that I could tweak to be relevant to the more advance dataset. Possibly even add a macro.