offset formula or any other function??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=LOOKUP(2,1/(A1:A1000<>""),A1:A1000)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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...
 
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
(e-mail address removed)

Thanks,

Ivette
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF or SUMIFS help 1
"OR" Function in an Array Formula 2
Obtain a Year to Date result without all cells of data being fille 3
How do I extract the decimal places from a number in excel? 3
Question using DGET function 1
Automating a computation process 3
How to use VLookup with a range of numbers? 3
How do I find if any numbers from a set add up to a given total? 3

Back
Top