offset formula or any other function??
 

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

offset formula or any other function??
 

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

--
HTH

Bob Phillips

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

"Sanj" wrote in message
...
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

offset formula or any other function??
 

Thanks. It works fine.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Sanj" wrote in message
...
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

offset formula or any other function??
 

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


Thanks,

Ivette

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"Sanj" wrote in message
...
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