View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gaurav[_3_] Gaurav[_3_] is offline
external usenet poster
 
Posts: 127
Default How to do this formula?!

Following will return the last value entered in the column.

=LOOKUP(2,1/(A1:A65535<""),A1:A65535)

If you want it to be a part of another formula, please post your current
formula here.


"jimmy" wrote in message
...
Hello,

would like to know if someone can help me.

My question is:

Which formula i have to use to have in one of the excel sheet thee last
value that appeared in another sheet?

Exp:
In the sheet 1 i have a set of values
day 1 = 20
day 2 = 30
day 3 = 40
Today = 60

In the other sheet i have to use a formula that calculates the result with
the today´s value.

Well, i think there is a way of doing that automatically without change
everyday the the cells in the formula.

If someone could help!!

Thanks