Function

A

Aladin Akyurek

I guess you want the last numerical value... Try:

=LOOKUP(9.99999999999999E+307,A:A)
 
M

mimi

Would anyone be able to tell me how to do the following:

I have a list of figures, which will be added to at th
ebottom of the list on a daily basis. I would like, in
another cell within another worksheet, to always return
this last figure from the list.

Any ideas?

Many thanks
 
J

Jason Morin

If the list were in A1:A20, you could use:

=LOOKUP(9E+307,A1:A20)

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top