Last value in a row greater than zero

[redbullsean]

Hello,
I have a data set that I need to get the last value in the row that is greater than zero. It seems so simple however I am having trouble and can't seem to get it.


Please help

 

[Rick Rothstein]

Hello,
I have a data set that I need to get the last value in the row that is greater than zero. It seems so simple however I am having trouble and can't seem to get it.

Try this formula...

=LOOKUP(9.9999999999E+307,C1:K1)

where you would change the C1:K1 to whatever overall range your numbers could possibly be in.

 

[Momentman]

I think that will find the last value in the row but necessarily greater than zero

=LOOKUP(9.9999999999E+307,C1:K1)

Excel 2010
	I	J	K	L	M	N	O
1	-10	4	-9	-3	10	5	-10
2
3	5
jameeee

Cell Formulas
Range	Formula
I3	=LOOKUP(2,1/(I1:O1>0),I1:O1)

 

[Rick Rothstein]

Try this formula...

=LOOKUP(9.9999999999E+307,C1:K1)

where you would change the C1:K1 to whatever overall range your numbers could possibly be in.

Ignore this message... I just noticed you asked for values greater than 0 (use the formula Momentman posted in Message #3 instead).

 

[redbullsean]

Thank You Both, That was incredibly fast!!!!!!