Hi,
I have the following formula to pull the first non-zero value from a column:
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
I have the following formula to pull the first non-zero value from a column:
Excel Formula:
=INDEX(N2:N200,MATCH(TRUE,INDEX((N2:N200<>0),0),0))
Column N contains numbers only: either zeros, or something >0