Hi,
I have a spreadsheet that lists Client in column A, Dates in column B, and data in column C.
However, there are dates missing and I'd like to:
- Fill in missing dates for each client including all dates until the end of the last month in the data.
- When my dates start after the beginning of the month, I'm missing the days from the beginning until then. Ideally I'd fill those in too with the data from the earliest day of the month.
The data should also take the previous date's value.
Becomes...
So far this is all I could find, which doesn't go until the end of the month when the client changes.
Ultimately I want to get the average data for each month including missing dates PER CLIENT.
Any help is appreciated.
Bookmarks