Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cell to return value in last cell in a column (2003)

    I have a spreadsheet with several columns of data. Each day we add a number to the bottom of column D. Is there a way for cell A1 to display the number in the last cell in column D.. and update to match when we add new data to end of the column? For instance, today the last cell in column D may be D400. Tomorrow it will be D401 and I need A1 to reflect the value in D400 today and D401 tomorrow.

    Probably simple. But it escapes me.

    Thanks!

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell to return value in last cell in a column (2003)

    Does this post help you?

    <post#=414159>post 414159</post#>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell to return value in last cell in a column (2003)

    =LOOKUP(9.99999999999999E+307,D)
    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •