Deleting duplicate rows keeping lowest value in column B With criteria

[Twinkievizzio11]

I have product codes in column A, prices in column B, and Names in Column C.

I Am looking for help with a formula or a macro to do the following:

Delete duplicate rows in column A but keeping the lowest dollar value B. Also if the lowest dollar values are duplicates then I would need a hierarchy of selection from Column C. First “medassets” second “premier” if those don’t exist then just select the lowest price.

Please help.

Thank you

 

[Twinkievizzio11]

Sorry, the Product codes are in Column C, Prices in Column F, and Name in Column B.

If anyone can assist I would really appreciate it.