Find the first value in a column greater than zero

[HKB]

I have a data that has 4 columns.The rows after some point will have a value of zero.

I need to get the value of the Next row of column which is greater than zero.

For example; the value in row 1 to appear in first cell in a row that is greater than zero.

Test file attached here with

Thanks in Advance

 

[Deepak]

Your explanations are bit confusing.

Is this..

A1 =INDEX(A2:A16,MATCH(TRUE,A2:A16>0,0))

Ctrl+Shift+Enter

 

[HKB]

Your explanations are bit confusing.

Is this..

A1 =INDEX(A2:A16,MATCH(TRUE,A2:A16>0,0))

Ctrl+Shift+Enter

Thanks Deepak ,
It's Work fine

 

[Khalid NGO]

Hi HKB,

Adding one more Index to Deepak's solution, makes it Non-CSE:

=INDEX(A2:A16,MATCH(1,INDEX(--(A2:A16>0),),0))

Regards,

 

[Deepak]

Hi HKB,

Adding one more Index to Deepak's solution, makes it Non-CSE:

=INDEX(A2:A16,MATCH(1,INDEX(--(A2:A16>0),),0))

Regards,

Revisited @Khalid approach.

=INDEX(A2:A16,MATCH(TRUE,INDEX(A2:A16>0,),0))

 

[bosco_yip]

Another non-CSE approach :

=INDEX(A2:A16,INDEX(MATCH(,1-(A2:A16>0),),))

Regards