Have 365 rows with a formula that sets the value equal to the previous row's, then replace the values on the days the data changes with set numbers? You can have another column with the date to make it easier to find the right dates to enter the numbers.
no subject
Date: 2012-02-28 09:05 pm (UTC)You can have another column with the date to make it easier to find the right dates to enter the numbers.