Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Take last entry of list and copy to bottom row (Ex

    I have a table that I fill in daily values, and then there is a summary that is calculated for the last day of the month that sits to the right of the table. What I would like to do is have the current day's values be copied to the last day of the month during the month so that if today is the 15th, the values from the 15th appear in the 30th row. Then my month end summary calculations could take place.

    The real solution would be to have the summary calculations to use the data form the current day of the month. I think I could use the current day to calculate off of the row that matched (Today()), but I would like to know if there was a way to determine the row to use, and about copying those values down to that last row. If there is a better way to do it, please let me know. I am stumped at this point.

    Thanks,

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Take last entry of list and copy to bottom row (Ex

    Using the value for today appears to be a better solution to me than copying today's value to the last row.
    Say that the values for this month are in A2:A31. The formula

    =INDEX(A2:A31,MATCH(9.99999999999999E+307,A2:A31))

    will return the last filled in (numeric) value in A2:A31.

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Take last entry of list and copy to bottom row

    Thanks Hans! I added a Monthly Summary row at the bottom and used your formula to bring down the latest value. Then my summary calculations are always up to date. Works like a champ. Thanks!

Posting Permissions

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