Minimum, excl zero - non-array/range

[Marelize]

Good day
I want to obtain the lowest price for certain products from different suppliers. And then decide which company has the overall lowest prices. The data is not in a range, but in various columns in one row.
In this mini sheet it is the highlighted columns.

Column AG and AH refers.
In AG I want to have the minimum price but without giving me zero as a minimum, while in AH I would like to get the company name as return (Z1, S1, L1).

This I accomplished by using MIN-function (but it returns zero too) and then using MATCH to get the company names.
But how do I eliminate the zero as a return...?

First time poster. English second language.

Thank you
Marelize

Soymaster chemies.xlsx
	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
2	Prys per verpakking (kan / boks)	Aankoopkoste vir seisoen	Rand per eenheid			Rand per hektaar	Gebruikte koste per seisoen	Prys per verpakking	Aankoopkoste vir seisoen	Rand per eenheid	per		Rand per hektaar	Gebruikte koste per seisoen	Prys per verpakking	Aankoopkoste vir seisoen	Rand per eenheid	per		Rand per hektaar	Gebruikte koste per seisoen	Lowest Price / Laagste Prys	lowest price company's name
3	R1,590.00	R6,360.00	R79.50	/	lt	R11.93	R5,962.50	R2,100.00	R8,400.00	R105.00	/	lt	R15.75	R7,875.00	R800.00	R3,200.00	R40.00	/	lt	R6.00	R3,000.00	R3,200.00	Farm-Agri
4	R2,342.86	R4,685.72	R117.14	/	lt	R9.37	R4,685.72	R2,500.00	R5,000.00	R125.00	/	lt	R10.00	R5,000.00	R7,500.00	R15,000.00	R375.00	/	lt	R30.00	R15,000.00	R4,685.72	Oos-Vaal
5	R3,720.00	R14,880.00	R372.00	/	lt	R48.36	R12,090.00	R2,950.00	R11,800.00	R295.00	/	lt	R38.35	R9,587.50				/	lt				Farm-Agri
6	R1,300.00	R5,200.00	R65.00	/	kg	R16.25	R4,062.50	R1,150.00	R4,600.00	R57.50	/	kg	R14.38	R3,593.75				/	kg
7	R1,800.00	R10,800.00	R360.00	/	lt	R39.60	R9,900.00	R1,200.00	R7,200.00	R240.00	/	lt	R26.40	R6,600.00	R1,950.00	R11,700.00	R390.00	/	lt	R42.90	R10,725.00	R7,200.00	Farmer's Agri-Care
Oos-Vaal

Cell Formulas
Range	Formula
M3:M7	M3	=IFERROR(K3*L3,0)
N3:N7	N3	=IFERROR(L3/D3,0)
P3:P7	P3	=E3
Q3:Q7	Q3	=IFERROR(F3/1000*N3,0)
R3:R7	R3	=IFERROR(Q3*I3*H3,0)
T3:T7	T3	=S3*K3
U3:U7	U3	=IFERROR(S3/D3,0)
X3:X7	X3	=F3/1000*U3
Y3:Y7	Y3	=X3*I3*H3
AA3:AA7	AA3	=Z3*K3
AB3:AB7	AB3	=IFERROR(Z3/D3,0)
AE3:AE7	AE3	=F3/1000*AB3
AF3:AF7	AF3	=AE3*H3*I3
AG6:AG7,AG3:AG4	AG3	=IF(MIN(AA3,T3,M3)=0,"",(MIN(AA3,T3,M3)))
AH3	AH3	=IF(MATCH(AG3,L3:AF3,0)=16,$Z$1,IF(MATCH(AG3,L3:AF3,0)=9,$S$1,IF(MATCH(AG3,L3:AF3,0)=2,$L$1)))
AH4:AH7	AH4	=IFERROR(IF(MATCH(AG4,L4:AF4,0)=16,$Z$1,IF(MATCH(AG4,L4:AF4,0)=9,$S$1,IF(MATCH(AG4,L4:AF4,0)=2,$L$1))),0)

 

[Fluff]

Hi & welcome to MrExcel.
Can you re-post the data from col D onwards.

 

[Marelize]

Did a quick translation addition to title row. Hope it makes sense

Soymaster chemies.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1									Oos-Vaal							Farmer's Agri-Care							Farm-Agri
2	Produkverpakking (kan / boks)	lt, ml, kg	used / ha Aanwending / ha		Total hectares Aantal hektare	Spray count Aantal bespuitings	Total Spray hoeveelheid vir hektare (in lt/kg)	Quantity units Aantal kanne / bokse te koop	Price per unite Prys per verpakking (kan / boks)	Cost buyed for season Aankoopkoste vir seisoen	Price per lt / kg Rand per eenheid			Price per hectare Rand per hektaar	Cost used Gebruikte koste per seisoen	Prys per verpakking	Aankoopkoste vir seisoen	Rand per eenheid	per		Rand per hektaar	Gebruikte koste per seisoen	Prys per verpakking	Aankoopkoste vir seisoen	Rand per eenheid	per		Rand per hektaar	Gebruikte koste per seisoen	Lowest Price / Laagste Prys	lowest price company's name
3	20	lt	150	ml	250	2	75	4	R1,590.00	R6,360.00	R79.50	/	lt	R11.93	R5,962.50	R2,100.00	R8,400.00	R105.00	/	lt	R15.75	R7,875.00	R800.00	R3,200.00	R40.00	/	lt	R6.00	R3,000.00	R3,200.00	Farm-Agri
4	20	lt	80	ml	250	2	40	2	R2,342.86	R4,685.72	R117.14	/	lt	R9.37	R4,685.72	R2,500.00	R5,000.00	R125.00	/	lt	R10.00	R5,000.00	R7,500.00	R15,000.00	R375.00	/	lt	R30.00	R15,000.00	R4,685.72	Oos-Vaal
5	10	lt	130	ml	250	1	32.5	4	R3,720.00	R14,880.00	R372.00	/	lt	R48.36	R12,090.00	R2,950.00	R11,800.00	R295.00	/	lt	R38.35	R9,587.50				/	lt				Farm-Agri
6	20	kg	250	g	250	1	62.5	4	R1,300.00	R5,200.00	R65.00	/	kg	R16.25	R4,062.50	R1,150.00	R4,600.00	R57.50	/	kg	R14.38	R3,593.75				/	kg
7	5	lt	110	ml	250	1	27.5	6	R1,800.00	R10,800.00	R360.00	/	lt	R39.60	R9,900.00	R1,200.00	R7,200.00	R240.00	/	lt	R26.40	R6,600.00	R1,950.00	R11,700.00	R390.00	/	lt	R42.90	R10,725.00	R7,200.00	Farmer's Agri-Care
8	20	lt	1000	ml	250	3	750	38	R800.00	R30,400.00	R40.00	/	lt	R40.00	R30,000.00				/							/
9												/							/							/
Oos-Vaal

Cell Formulas
Range	Formula
J3:J9	J3	=(F3*H3*I3)/1000
K3:K9	K3	=IFERROR(ROUNDUP(J3/D3,0),0)
M3:M9	M3	=IFERROR(K3*L3,0)
N3:N9	N3	=IFERROR(L3/D3,0)
Q3:Q9	Q3	=IFERROR(F3/1000*N3,0)
R3:R9	R3	=IFERROR(Q3*I3*H3,0)
T3:T9	T3	=S3*K3
U3:U9	U3	=IFERROR(S3/D3,0)
X3:X9	X3	=F3/1000*U3
Y3:Y9	Y3	=X3*I3*H3
AA3:AA9	AA3	=Z3*K3
AB3:AB9	AB3	=IFERROR(Z3/D3,0)
AE3:AE9	AE3	=F3/1000*AB3
AF3:AF9	AF3	=AE3*H3*I3
AG6:AG9,AG3:AG4	AG3	=IF(MIN(AA3,T3,M3)=0,"",(MIN(AA3,T3,M3)))
AH3	AH3	=IF(MATCH(AG3,L3:AF3,0)=16,$Z$1,IF(MATCH(AG3,L3:AF3,0)=9,$S$1,IF(MATCH(AG3,L3:AF3,0)=2,$L$1)))
AH4:AH9	AH4	=IFERROR(IF(MATCH(AG4,L4:AF4,0)=16,$Z$1,IF(MATCH(AG4,L4:AF4,0)=9,$S$1,IF(MATCH(AG4,L4:AF4,0)=2,$L$1))),0)
P3:P8	P3	=E3

 

[Fluff]

Thanks for that.
How about

=IF(AG3="","",IFERROR(IF(MATCH(AG3,L3:AF3,0)=16,$Z$1,IF(MATCH(AG3,L3:AF3,0)=9,$S$1,IF(MATCH(AG3,L3:AF3,0)=2,$L$1))),0))

 

[Marelize]

Thanks for that.
How about

=IF(AG3="","",IFERROR(IF(MATCH(AG3,L3:AF3,0)=16,$Z$1,IF(MATCH(AG3,L3:AF3,0)=9,$S$1,IF(MATCH(AG3,L3:AF3,0)=2,$L$1))),0))

Thanks
But I still need the AG column to not return zero as a minimum.
Example: Supplier 3 doesn't carry product ABC, so his price for this would remain empty "zero". Excel picks this then as the minimum instead of omitting the zero and taking second lowest price as minimum.

Thus how can I get it to not use zero as a minimum...?

 

[Fluff]

I still need the AG column to not return zero as a minimum.

It doesn't, the formula in AG returns "" if the min is zero.

 

[Marelize]

I realize that, but I want the lowest price for a product, not a zero or empty price.

Eg I buy butter for $10 at store ABC, $12 at store XYZ but store DDD doesn't stock butter. I want to determine the lowest price, not the zero (non-stockist) as the minimum... And because my data is not in a range / array (all together like in a column or a row) the function "SMALL", which would be perfect, doesn't work...
Maybe I should rather look at a database type program and not use Excel for this?

 

[Fluff]

Ok, how about

=IFERROR(1/(1/AGGREGATE(15,6,M3:AA3/(M3:AA3<>0)/(MOD(COLUMN(M3:AA3),7)=6),1)),"")