Cell is "Last value" in range

[Guest]

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

 

[Paul B]

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

 

[Guest]

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