Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Populate with last entry (2002)

    I want to search a column for the last cell that contains a number and put that value into another cell. This spreadsheet will get very lengthy and I would like to keep all pertinent information at the top in a frozen pane section so it is visible as soon as the file is opened. Is there a formula that will do this? I have tried myself, but have yet to come up with anything. Let me know if you have any ideas. If this has been discussed already, kindly point me in the right direction! Thanks a lot.

    Sarah

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Populate with last entry (2002)

    Hi Sarah,
    You can put the following formula in cell A1 to retrieve the last number value in column A:
    =OFFSET(A1,MATCH(9.99999999999999E+307,A2:A65536), 0)
    (it's a variation on the post by Aladin <!post=here,164025>here<!/post>)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Populate with last entry (2002)

    Thanks, Rory. It's working great!
    S

Posting Permissions

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