Return The Value In The Last Filled Cell

Claire · Sep 29th 2005

Hi,
i'm looking for a formula that will return the last value in a row of values, such that this would be the current value for another formula.

Any help would be apprecited.

Cheers

pangolin · Sep 29th 2005

Re: Return The Value In The Last Filled Cell

use the LOOKUP function

for eg

Code

=LOOKUP(9.999999999999E+307,A2:AB2)

Claire · Sep 29th 2005

Re: Return The Value In The Last Filled Cell

Thanks very much

Participate now!