Hello Experts,
This is my first of (I'm sure of) many posts. My question today is, How do I calculate the max for a specific entity over a set window of time?
In this case, I would like to calculate the maximum consumption/usage of a specific material over any 30-day window inside of the year. The first two points can be taken care of with a MAXIFS, but I don't understand how to have excel evaluate every 30-day instance for each material. Seems doable, I think I am just lacking the knowledge. Any advice would be appreciated!
A small sheet with sample data should be attached.
Best,
Plenty o' Questions
Bookmarks