How to do this formula?!
 

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

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

How to do this formula?!
 

=LOOKUP(99^99,B:B)

Will return the last value entered in column B - adjust as necessary.

"jimmy" wrote:

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