Spilled array formula to match the minimum But above 0 of each row in a 2D table

[ED38]

Hello All,

I am struggeluing with a formula to get an array showing the minimum of each row of a 2D table like the case solved here :

Spilled array formula to match column for minimum of each row in a 2D table

I have a 2D table of timeseries data. I am able to use the following equation in column B: "=BYROW(Value_Array,LAMBDA(x,MIN(x)))" to get the minimum value for each row that results in an array output. In column C the following does not work "=BYROW(Value_Array,LAMBDA(x,MATCH(B6#,x,0)))" to find...

www.mrexcel.com

BUt with an add'l condition : I need the lowest positive value. I Have hard time to find and you help is welcome :

Here is what I tried and what i expect. Thank you for your help :

 

[shift-del]

Try this.

Mappe26
	A	B	C	D	E	F	G	H
3							Expected result	Actual result
4	81	402	249	295	484		81	81
5	67	768	0	0	0		67	67
6	253	350	603	415	123		123	123
7	65	86	892	14	511		14	14
8	0	0	396	0	0		396	396
Tabelle1

Cell Formulas
Range	Formula
H4:H8	H4	=BYROW(A4:E8,LAMBDA(x,MINIFS(x,x,">0")))
Dynamic array formulas.

 

[ED38]

Perfect, it works well!
thank a lot shift-del