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

Copper Contributor

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 Year and Month (from about 30 days in a typical month).  How can I specify an array for a given Year and Month for LARGE to find the largest value?

2 Replies

@David_5091 

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