SINGLE POSITIVE MIN value

[Maurizio]

How can I get the SINGLE POSITIVE (because purchase) MIN value so:

MINIMO.xls
	A	B	C	D	E	F	G	H
1	Purcase	A01	TUBOACCIAIO	4,00	13,482		53,93	MIN(13,483)
2	Sale	A01	TUBOACCIAIO	-4,00	12,798		51,19
3	Purcase	A01	TUBOACCIAIO	5,00	15,760	5,00%	74,86
4	Sale	A01	TUBOACCIAIO	-5,00	15,760	5,00%	74,86
5	Purcase	A01	TUBOACCIAIO	6,00	51,130	50,00%	153,39	MAX(25,565)
6	Sale	A01	TUBOACCIAIO	-6,00	51,130	50,00%	153,39
7
8	HowcanIgettheSINGLEPOSITIVE(becausepurchase)MINvalueso:
9	A01	MAX	25,565	{=MAX(IF(B1:B6=A10,G1:G6/D1:D6))}
10		MIN	13,483	???
MIN_MAX

 

[plettieri]

For us new guys, could you explain a little bit more "what do you mean single positive"?
pll

 

[Maurizio]

For "single positive" I mean that the value in column "D" is >0.
Hi.

 

[Aladin Akyurek]

Array-enter:

=MIN(IF(B1:B6=A9,IF(D1:D6>0,G1:G6/D1:D6)))

Your condition for B-range is in A9, not A10!

 

[Maurizio]

Hi Aladin Akyurek, you are formidable.
Thank you, Ciao!