Home > Enterprise >  Excel - find the average of the top 3 prices for each product type
Excel - find the average of the top 3 prices for each product type

Time:09-23

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 

enter image description here

  • Related