T
thuyhong
Hello everyone -
I am desperately in need of help:
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:
Column A ------ Column B ------- Column C
1/6/2006 ------- CompanyA ------- 25
1/6/2006 ----------CompanyA ------- 50
1/7/2006 --------- CompanyB ---------100
1/8/2006 ----------CompanyB -----------125
1/9/2006 ----------CompnayA -----------52
1/9/2006 ----------CompanyA ----------50
1/10/2006 --------CompanyB ---------- 200
With the example above I would like excel to recognize that on
1/6/2006 companyB have no data and to insert a row with 1/6/2006 ---
CompanyB ---0
If both company A and B have no data then just insert 0's in... the
reason for this is when graph I would like to see the low day/week/
monthly average...
Can anyone help me with this?
I also posted this question on [http://www.mrexcel.com/board2/
viewtopic.php?t=287266]
I am desperately in need of help:
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:
Column A ------ Column B ------- Column C
1/6/2006 ------- CompanyA ------- 25
1/6/2006 ----------CompanyA ------- 50
1/7/2006 --------- CompanyB ---------100
1/8/2006 ----------CompanyB -----------125
1/9/2006 ----------CompnayA -----------52
1/9/2006 ----------CompanyA ----------50
1/10/2006 --------CompanyB ---------- 200
With the example above I would like excel to recognize that on
1/6/2006 companyB have no data and to insert a row with 1/6/2006 ---
CompanyB ---0
If both company A and B have no data then just insert 0's in... the
reason for this is when graph I would like to see the low day/week/
monthly average...
Can anyone help me with this?
I also posted this question on [http://www.mrexcel.com/board2/
viewtopic.php?t=287266]