Match and average similar data

[P91]

Hi

I have a sheet with many, many items of data looking a number of products and various specifications associated with it. Amongst the specs there is test data for each product, i.e. the efficiency of each product - however in my data there are duplicates of a particular product, as in the test has been run multiple times but each time it gives a different efficiency value. Example Below

Product	Efficiency	Match	Average
Red	32	1	32+33+35/3
Red	33	1	[BLANK]
Red	35	1	[BLANK]
Blue	56	2	56+57/2
Blue Stripes	63	3	63
Blue	57	2	[BLANK]

I wanted to average values if they matched names for examples (there's more criteria to be matched but if I get the gist of it, it should be easy enough to do), but I want the formula to run through the entire list, matching groups together and then averaging them based on other cell data. Ideally, I'd like to only have the average value in the first instance that product appears on the list, and leaving the rest blank.

Not sure where to start with this.