2 colums of data, trying to specify cheapest one of groups by matching names

Hello,

I'am trying to see if it is possble to, with the attached data, that is sorted by "variant name" (column A) asside from the spaces, look through column A to find groups of "variant names" that are the same, then compare the prices (column c) of these rows in the "variant name" groups and in column B enter yes for the cheapest one of the "variant name" group and no for the rest.

Considering that in some "variant name" groups the prices may all be the same and then it would not matter which one was selected the first one down the list or last is as good as any if thats easiest or also there may be several different prices for items in the "variant name" groups but there may be more than one of them that are the cheapest price, again it would not matter which one was made to be yes in colum B of these matching cheapest prices with in a "variant name" group but - only 1 of any "variant name" group can be yes the rest have to be no.

This is a bit complicated, but I hope it makes sense. Hopefully this is possible, but I dont have the excel skills to be able to knock up the code required to do this.

I hope someone can help.

Best regards,

Paul