How to specify a dynamic array for finding the largest value?

Question

I am using the Microsoft 365 version of Excel on a PC running Win 10.&nbsp;&nbsp;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 Year and Month (from about 30 days in a typical month).&nbsp; How can I specify an array for a given Year and Month for LARGE to find the largest value?

sergeibaklan · Answer

David_5091&nbsp;
You may use MAXIFS(), or FILTER() on month/year and take the max of parameter column.

david_5091 · Answer

Many thanks.

Forum Discussion

How to specify a dynamic array for finding the largest value?

2 Replies

Resources