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
|