Forum Discussion
Can I use the LARGE function with MAXIFS?
Hi, I'm using the MAXIFS to extract data from a large spreadsheet. To make it more accurate I want to ignore the largest item from the data. Can I use the LARGE function with the MAXIFS formula?...
=LARGE(IF(($A$3:$A$20=E5)*(YEAR($B$3:$B$20)=F5),$C$3:$C$20),2)If you want the 2nd largest result with certain conditions you can try LARGE and IF. If you don't work with Office365 or Excel 2021 or Excel online you have to enter the formula with ctrl+shift+enter.