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
|