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...
Thanks ! Yes I'm using 365. 🙂 This formula looks very sophisticated.
I'm bit confused how to use this though.
I'm bit confused how to use this though.
This should at least demonstrate that the formula does work, even though how it works may remain a mystery. For me the good news is that Excel 365 is a very different app that enables completely different solution strategies. For everyone else, the good news may be that it is backward compatible, so you can keep on churning out the old familiar stuff!
- Thanks for the info ! What I am not clear is , what formula did you write to find the purchase date 1, date 2 , date3 and what formula was used to find respective quantities.
Sorry, I meant to attach the file. The formulas are to be found in cells F5 and G5.
The key elements of the formula are the terms
UNIQUE(FILTER(PurchaseDate, Product=@distinctProduct#)) and SUMIFS(Quantiy, Product, @distinctProduct#, PurchaseDate, date)which return the dates associated with a given product and the change for each product and date respectively. The rest is just to satisfy your formatting requirements.