Formula to find the the highest sum of a consecutive list of data
I need help trying to figure out a formula that will find the max consumption qty of a particular item on a given day. The tricky part is that there are multiple instances per day of consumption for each item.
It would need to to understand that each day is also a unique identifier and sum accordingly per item.
Help Article Resources
Check out the Formula Handbook template!