Forum Discussion
How to specify a dynamic array for finding the largest value?
I am using the Microsoft 365 version of Excel on a PC running Win 10. I have a table with 4 columns: Year, Month, Day and Parameter. I want to find the largest value of the Parameter for a given Yea...
You may use MAXIFS(), or FILTER() on month/year and take the max of parameter column.
- Many thanks.
