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 !

Hi,

Could the following be your solution :

http://groups.google.com/group/micro...8 90840b7e454

HTH
Cheers
Carim

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" wrote:

Hi,

Could the following be your solution :

http://groups.google.com/group/micro...8 90840b7e454

HTH
Cheers
Carim

Could Max() function help ...

=Max(A2:A100)

Carim

=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)

"IvanM" wrote in message
...
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 !

With an array function :

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

Control+Shift+Enter instead of Enter to accept formula

HTH
Cheers
Carim

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" wrote:

=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)

"IvanM" wrote in message
...
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 !

(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)

"IvanM" wrote in message
...
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" wrote:

=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)

"IvanM" wrote in message
...
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 !

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

"Bob Phillips" wrote in message ...
(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)

"IvanM" wrote in message
...
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" wrote:

=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)

"IvanM" wrote in message
...
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 !