Calculating Averages of specific products from columns

Hello!

I'm looking to calculate average selling prices for these models. I want to create a formula that searches the model name in column A and then takes an average price from column B of all the same model. See excel attachment for better understanding. Thank you in advance!

Also imagine Column A/B having 500 items total.

Example:

Model Price
A136 $428.00
A136 $435.00 Averages
A137 $582.00
A138 $349.00 A136:
A137 $594.00 A137:
A136 $437.00 A138:

Try this:

Please Login or Register  to view this content.

Genius! Thanks.