How to filter rows by a complex condition (only the best offer for each product)?

Question

Google Sheets

We have a Google spreadsheet:
https://goo.gl/P74wpz
Columns in it:
Model name Total
price
Link to the corresponding price
Other necessary columns
Image

Question: How to leave only those rows in which the minimum prices of each product

Answer 1

One of the options for solving the problem was in the Disk Community
The formula for the minimum price

=FILTER('данные'!A1:E14;MMULT(('данные'!A1:A14=TRANSPOSE('данные'!A1:A14))*('данные'!B1:B14>TRANSPOSE('данные'!B1:B14));SIGN(ROW('данные'!B1:B14)))=0)

Answer 2

group by
having min
xs is it possible with google scripts