Find second (third...) non-zero value in a column

[virtuosok]

Hi,
I have the following formula to pull the first non-zero value from a column:

=INDEX(N2:N200,MATCH(TRUE,INDEX((N2:N200<>0),0),0))

Which formula should I use to pull the second (third, fourth...) non-zero value? I need at least first 7, ideally first 10 values from the column.
Column N contains numbers only: either zeros, or something >0

 

[Fluff]

How about in O2 dragged down

=INDEX($N$2:$N$200,AGGREGATE(15,6,(ROW($N$2:$N$200)-ROW($N$2)+1)/($N$2:$N$200>0),ROWS(O$2:O2)))

 

[virtuosok]

Phenomenal! This works! THANKS!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[virtuosok]

One more question though as I also need another formula for matches (in a different column).
is it also possible to pull the adjacent value from column J? I.e. in the above scenario wherever there's >0 value in column N (let's say this happens in cell N20), the formula pulls the value from J20?

 

[Fluff]

Just change the range being indexed.

 

[virtuosok]

The problem is that column J doesn't have zero values, all entries in there are >0
Sorry for not mentioning this upfront!

 

[virtuosok]

Oops sorry, figured out. Only first part of the formula needed a change... issue solved!

 

[Fluff]

Glad you sorted it & thanks for the feedback.