Slicemahn
12-28-2007, 05:45 AM
Hello Everyone,
I am looking to create some formulas in the columnar format that an Excel pivot table failed to do. My problem is that this data is going to change daily so I can't add formulas and copy down because :
1) the data sets are 32K rows and 5 tabs
2) Time
So I would appreciate any help on this one. I would need to calculate the % of Cable Total and then all sum the total calls. I have attached the spreadsheet with the before and after.
Many thanks for your thoughts and suggestions
Slice
I am looking to create some formulas in the columnar format that an Excel pivot table failed to do. My problem is that this data is going to change daily so I can't add formulas and copy down because :
1) the data sets are 32K rows and 5 tabs
2) Time
So I would appreciate any help on this one. I would need to calculate the % of Cable Total and then all sum the total calls. I have attached the spreadsheet with the before and after.
Many thanks for your thoughts and suggestions
Slice