Good morning! I'm currently looking for help on a problem I've been facing in Excel. I'm trying to process a massive amount of data. To be specific, I'm referencing 17,352,100 rows. Fortunately, I don't plan on processing or working with all of them at once. I'm running sales data for different items. Each item has a daily sales amount. This means each item gets 365 rows just to itself. I'm looking to calculate everything down to thirteen four-week periods. I'm looking for a formula (or other solution) that will look at each item, pick out the four weeks worth of dates, and total the sales amounts for each day.
My plan is to set something up so that I can process about 500 items at a time, copy/paste the results, wash, rinse, and repeat. This will also be something that in the future, I can hopefully just alter the dates and use again. I can only think of formulas that are too long to create. Any help anyone can offer would be great.
Below, I have copied a sample of two codes. I need to break down the sales days into four week intervals. The first interval would be 10/08/14 to 11/07/14. If you have any questions or need any additional clarification, please let me know.
<tbody>
</tbody>
My plan is to set something up so that I can process about 500 items at a time, copy/paste the results, wash, rinse, and repeat. This will also be something that in the future, I can hopefully just alter the dates and use again. I can only think of formulas that are too long to create. Any help anyone can offer would be great.
Below, I have copied a sample of two codes. I need to break down the sales days into four week intervals. The first interval would be 10/08/14 to 11/07/14. If you have any questions or need any additional clarification, please let me know.
<tbody> </tbody> |
<tbody>
</tbody>
Last edited: