Switch Function - Two Criteria or Expressions

Hi everyone!

You can use this two formulas:

PHP Code: 

[B334] : =TAKE(SORT(FILTER(CHOOSECOLS(A7:M327,13,8,9,10,2),N7:N327=B333),,-1),5)
[B342] : =TAKE(SORT(CHOOSECOLS(A7:M327,13,8,9,10,2),,-1),10) 


The second option assumes that all your data belongs to year 2024 (you can add a 2024 filter if you consider it necessary). Blessings!