Last cell in column greater than zero?

[Justin]

Is there a function or group of functions that can display
the last cell in a column larger than Zero.

It can't just calculate the minimum number in the cells
greater than zero, because sometimes the last number is
greater than the cells above it. All I need is the last
cell in the column greater than zero.

Any help would be appreciated. Thank you in advance.

 

[Aladin Akyurek]

Do you mean to retrieve the last non-zero value from a column or to
determine the position of such a value?

 

[Frank Kabel]

Hi
why not use the following array formula (entered with
CTRL+SHIFT+ENTER):
=MIN(IF(A1:A1000>0,A1:A1000))

for getting the row number of last number >0 try:
=LOOKUP(2,1/(A1:A1000>0),ROW(A1:A1000))

 

[Justing]

I want to retrieve the last non-zero value from a column.

 

[Aladin Akyurek]

=LOOKUP(2,1/(A2:INDEX(A:A,MATCH(9.99999999999999E+307,A:A))<>0),A2:INDEX(A:A
,MATCH(9.99999999999999E+307,A:A)))

will retrieve the last non-zero numerical value from column A, housing data
from A2 on. If the neg values must be excluded from consideration,
substitute > for <> that figures in the formula.

 

[Justin]

The only problem with that formula is that it only enters
the minnimum number in the column greater than zero, not
the last number greater than zero which is what I need.
Any other suggestions?

 

[Justin]

All I can say is WOW!

Thank you so much. That formula is amazing!!!

 

[Frank Kabel]

Hi
for the last value >0 either use Aladin's formula or:
=LOOKUP(2,1/(A1:A1000>0),A1:A1000)

Not sure but Aladin's formula could be faster as it only searches the
range with filled values