J
Jake8
I have a column of formulas. The data I am entering will give a result
for each of the formulas sequentially ie there no nonzero results up to
a point. What I need to know is where the nonzero results start and to
log the last nonzero value. The column of formulas is 50 deep. I was
thinking take the average and where the average rises above zero that
cell would be the cell I am after but is there a better way?
for each of the formulas sequentially ie there no nonzero results up to
a point. What I need to know is where the nonzero results start and to
log the last nonzero value. The column of formulas is 50 deep. I was
thinking take the average and where the average rises above zero that
cell would be the cell I am after but is there a better way?