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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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!

Reply | Quote