Delete Duplicate Entire Rows Keeping Row with Lowest Price

Hi Guys,

I have a database with a ton of duplicate entries where each column is the exact same data in multiple rows except for the price column. I would like to figure out a quick way to delete duplicates keeping the row with the lowest price. I can sort to make it simpler. i have attached a spreadsheet with a sample of data.

Thanks

Also, does anyone know a good advanced excel book to learn macros and VBA?