I have a list of clothes (shirts, jumpers, pants and jackets) in different colors and sizes in the first column. The second column lists the prices for each of them. How do I write a formula to find the average of the top 3 prices for each type of clothing? I tried to do this using array formulas, but when I tried to use asterisks for the wildcard, nothing worked.
Brown jacket size M $50 Avg top-3 price
Black shirt size L $22 shirt $42
Blue pants size L $40 jumper $44
Grey jumper size L $49 pants $40
White jumper size M $47 jacket $39
Brown pants size L $44
White shirt size M $38
Black jacket size S $27
White jacket size L $41
Brown jumper size L $36
Blue jumper size S $23
Brown shirt size S $45
Black pants size S $37
Grey pants size M $31
Black jumper size M $30
Blue jacket size M $28
Grey jacket size S $21
Grey shirt size S $36
Blue shirt size M $44
White pants size S $36