Not sure how to phrase the question - 'sort to show cheapest price of parts?'

I am working on a database of mechanical parts used in making cars, from seats and stearing wheels right down to nuts and bolts, sold by different suppliers, with over 7,000 lines of information to sift through.

Column A - a list of part numbers
Column B - the name of the supplier selling that part
Column C - the price they are selling the part for

What I want is to add something into column D that will tell you which supplier sells that part for the lowest price.

I don't want to use filters that will reguire a specific search for each item and I don't want somethin that will remove information as it might be updated as prices change.

Any ideas?

So for the first entry, part 'AB1872' is supplied by supplier 'B4' at a price of '11.70' and in column D then 'B4' should show as they are the cheapest supplier of that part. 'B4' should then show against the other data for part 'AB1872'.

The next part is 'AB1885' and supplier 'H9' should show in column D for each entry for that part as they are the cheapest.

It would be great if this information was able to update itself as the prices were changed.

Part Supplier Npp Cheapest Supplier
AB1872 B4 11.70
AB1872 EB 13.16
AB1872 N2 17.00
AB1872 C4 18.70
AB1885 H9 36.00
AB1885 B4 36.50
AB1885 C4 37.80
AB1885 N2 55.00
CN2111 D2 12.00
FT1111 A9 15.00
FT1111 S2 12.50
FT1111 D5 19.75
FT1111 W1 13.25
ST2500 C4 12.00
ST2500 B4 15.00
ST2500 H9 11.95
TY1915 D6 33.00
TY1915 W5 45.00
TY1915 Q8 42.00
TY1915 S1 40.50