Hello,
I have a spreadsheet with 15-minute interval data for an entire year. I would like to pick out the maximum value (demand) from each month, and return the date and time which the max demand occurred.
To get the max demand for February, I have:
MAX(IF(MONTH(Table1[Date and Time])="2", Table1[[Demand ]:[Demand ]]))
Now to find the date at which this max occurred is where I am struggling. My attempt is:
INDEX(Table1, IF(MONTH(Table1[Date and Time])=2, MATCH(MAX_VALUE,Table1[[Demand ]],0),""),1)
Any suggestions? Sorry if I missed anything in the rules, this is my first post!
Bookmarks