offset formula or any other function??

S

Sanj

I need a formula where everytime I update with a new month's data, that
formula will pickup that number
For e.g. If I populate 145 right underneath 89, that formula will pickup 145
45
56
89

Sanj
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
S

Sanj

Thanks. It works fine.

Bob Phillips said:
=LOOKUP(2,1/(A1:A1000<>""),A1:A1000)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
I

izlopez

Hi Bob!

I saw this formula, and it certainly works, for what I was looking it, but,
I don't understand it. I would like to understand it, in order to reproduce
it by myself. Could you explain me how it works? Please answer me at
[email protected]

Thanks,

Ivette
 
Top