find last value in list

[Guest]

I am trying to find the last entered value in a list of basic weight data. I
enter new numeric values to the list on a daily basis, but would like to
always show the last entered value in another cell also.
Please help !

 

[Carim]

Hi,

Could the following be your solution :

http://groups.google.com/group/micr...?lnk=gst&q=last+value&rnum=1#8e16890840b7e454

HTH
Cheers
Carim

 

[Guest]

Thx Carim,
That doesn't seem to help or work, after trying those formulas,
I didn't give enough info though, the list also contains zero values, that I
want to exclude
from my result, e.g.
0
300
250
350
375
0
0
would always return 375, as the last value in the list (which will also
always be positive)
it is also the value I need, not the position.

Regards,

IvanM

 

[Carim]

Could Max() function help ...

=Max(A2:A100)

Carim

 

[Bob Phillips]

=LOOKUP(2,1/(A2:A100<>""),A2:A100)

set A100 as high as you are ever likely to need

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Carim]

With an array function :

=INDEX(A1:A10,MAX((A1:A10>0)*(ROW(A1:A10)))-ROW(A1:A10)+1)

Control+Shift+Enter instead of Enter to accept formula

HTH
Cheers
Carim

 

[Guest]

Thanks for the assistance Carim, but Max will only give me the largest value
if I remember correctly.

Thanks also to Bob, I changed the "" to 0, which ignored all the zero values
in my list, and it worked !
Thanks again, truly appreciated.

 

[Bob Phillips]

(If you want to ignore 0, then just try

=LOOKUP(2,1/A1:A1000,A1:A1000)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Epinn]

Bob,

In case you are interested, I have started my own thread (LOOKUP) based on this. I have discovered something interesting but quite lost.

By the way, thank you for explaining global naming.

Epinn

(If you want to ignore 0, then just try

=LOOKUP(2,1/A1:A1000,A1:A1000)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)