Use FILTER to get the right rows: =FILTER($A$2:$C$7,MAXIFS($C$2:$C$7,$A$2:$A$7,$A$2:$A$7)=$C$2:$C$7). The first parameter is the data range ...
確定! 回上一頁