Cell is "Last value" in range
 

Hi,

I have a question about getting the last value of a range en put this value
into another cell.

Is that possible?

Kind regards, Stefan van der Hooft

Cell is "Last value" in range
 

Stefan, numeric valve? Try this, =LOOKUP(9.99999999999999E+307,A:A)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Stefan van der Hooft" wrote
in message ...
Hi,

I have a question about getting the last value of a range en put this
value
into another cell.

Is that possible?

Kind regards, Stefan van der Hooft

Cell is "Last value" in range
 

Put this formula in the other cell:

=INDEX(B:B,MATCH(10^10,B:B))

Uses Index and match for a number larger than any number in your range...
will return last number. If you have anything bigger than ten to the tenth,
adjust accordingly. :-)
Can also be used with entire column, if desired:

=INDEX(B:B,MATCH(10^10,B:B))

"Stefan van der Hooft" wrote:

Hi,

I have a question about getting the last value of a range en put this value
into another cell.

Is that possible?

Kind regards, Stefan van der Hooft