Forum Discussion
Solved
Data Aggregation base on dates
Hi there, I want to aggregate purchase quantity base by date and place the result on a different cell. Can someone please shed some light on this. I am attaching the data table and output table he...
ImalkaJ are you familiar with pivot? The table has a different look, but in case you do not have too many product types, it might do. I attached the possible solution, plus I made the input table a Table formatted area. Add new row to input --> Table expands automatically --> right click to pivot --> refresh
- Thanks ! For this I am opting out pivot table. I am more after advanced formula/ learn if I have to use VBA for this.
