Learn when FILTER beats XLOOKUP, when it does not, and how to handle multiple matches, nth items, and multi-condition lookups with clear steps.

在做成绩表、销量统计时，手动给几十上百个数值排名太费劲了，不仅要反复核对“谁高谁低”，还容易漏排、错排。