i have a workbook with missing dates and would like excel to insert any missing dates and add 0's into that missing dates if there is no data...
for example
for example
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Company Name | Total | |||
2 | 1/2/2006 | A | 25 | |||
3 | 1/2/2006 | A | 35 | |||
4 | 1/3/2006 | B | 125 | |||
5 | 1/5/2006 | B | 20 | |||
6 | 1/5/2006 | B | 185 | |||
7 | 1/7/2006 | A | 200 | |||
8 | 1/8/2006 | B | 250 | |||
9 | 1/10/2006 | B | 250 | |||
10 | 1/10/2006 | A | 350 | |||
Sheet1 |