Finding min value from column against multiple criteria

[JV79]

Hello. I have hundreds of rows of data. Within these rows of data I have a company that is shown multiple times with different products and different amounts. I need to find the lowest (min) value, comparing Company and product (that are the same) against the amount. See example attached.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=C2=MINIFS($C$2:$C$500,$A$2:$A$500,A2,$B$2:$B$500,B2)

 

[JV79]

That worked perfectly! Sorry I didn't respond sooner. I was having computer issues. I appreciate your help and the quick response! Have a good evening!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[JV79]

You saved me so much time too. I had been grappling with a good formula for what I needed for such a long time, so again, thank you!!

 

[Fluff]

My pleasure.