Hi there,
I have large dataset going over thousands of records per day spanning a period of about 3 months. Luckily the data is dated so I can sort it by date.
I need to range this data as 1)per day, 2)per working week and 3)per month for further manipulation of data as required. Off days need to be factored in.
The dataset I have is just the first one and I am expecting to work through 10 to 15 additional such datasets initially and may be on an ongiong basis thereafter.
I am looking for a way to automate the date ranging of the datasets with the help of formulas, so that I can apply required formulas on daily, weekly and monthly data. Unfortunately my knowledge of VBA is non-existant.
Will appreciate any asisstance and pointers in the right direction.
Thanks in advance
Sohill
I have large dataset going over thousands of records per day spanning a period of about 3 months. Luckily the data is dated so I can sort it by date.
I need to range this data as 1)per day, 2)per working week and 3)per month for further manipulation of data as required. Off days need to be factored in.
The dataset I have is just the first one and I am expecting to work through 10 to 15 additional such datasets initially and may be on an ongiong basis thereafter.
I am looking for a way to automate the date ranging of the datasets with the help of formulas, so that I can apply required formulas on daily, weekly and monthly data. Unfortunately my knowledge of VBA is non-existant.
Will appreciate any asisstance and pointers in the right direction.
Thanks in advance
Sohill