Mar 15 2021 09:38 PM
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?
Mar 16 2021 01:57 AM
You may use MAXIFS(), or FILTER() on month/year and take the max of parameter column.
Mar 17 2021 09:50 PM