MinIfs Formula (or alternative approach) to find the lowest value per row based on 2 criteria

[Ben AFF]

Hi All, I need help please with a formula to find the lowest value for a given number of rows based on 2 criteria and then calculate the % difference.
The lowest value needs to be calculated for each row with 2 criteria.
To illustrate my data is structured as follows.
In the last column the lowest value should be calculated for each Product Serial and the different locations.

I have try a combination of minif formula approaches but none of them did work.

Appreciate please your help. Thank you.

Product Serial	Location	Price	This is what I need-> Lowest Price by Product Serial for all Locations
001	A	10	10
001	B	12	10
001	C	14	10
002	A	8	4
002	B	6	4
002	C	4	4
003	A	12	12
003	B	14	12
003	C	18	12

 

[Peter_SSs]

Like this?
You did mention 2 criteria but your sample seems to only use 1.

24 02 20.xlsm
	A	B	C	D
1	Product Serial	Location	Price	Lowest Price by Product Serial for all Locations
2	1	A	10	10
3	1	B	12	10
4	1	C	14	10
5	2	A	8	4
6	2	B	6	4
7	2	C	4	4
8	3	A	12	12
9	3	B	14	12
10	3	C	18	12
MINIFS

Cell Formulas
Range	Formula
D2:D10	D2	=MINIFS(C$2:C$10,A$2:A$10,A2)

 

[Ben AFF]

Thank you Peter, this worked.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.