Pick up the first positive (non Zero) number in a range

[masim]

Hi

here is my range starting from say C1.

-1920 -56 -988 0 0 95 25 1222

How can i pick first positive non zero number (in this case 95) ?

Thanks
Asim

 

[Haluk]

Hi all;

Considering various scenarios, this is my best and final offer ( )


=SMALL(C1:J1,COUNTIF(C1:J1,"<=0")+1)

 

[Aladin Akyurek]

Hi all;

Considering various scenarios, this is my best and final offer ( )


=SMALL(C1:J1,COUNTIF(C1:J1,"<=0")+1)

That would produce quite often a wrong number.

Book7
	C	D	E	F	G	H	I	J
1	0	0		-3	5	-7	-2	1
2
3	5
4	5
5
Sheet1

C3:

=INDEX(C1:J1,MATCH(TRUE,C1:J1>0,0))

which must be confirmed with control+shift+enter, not just with enter.

C4:

=INDEX(C1:J1,MATCH(1,INDEX(--(C1:J1>0),1,0),0))

which is simply confirmed with enter.

The Small formula would give here 1 as result, which is not an intended result.

 

[Haluk]

Aladin;

I shouldn't say "Considering various scenarios".... you're correct.

 

[masim]

Thanks Aladin & Co

This works a treat.

Regards
Asim