Excel - Here's how to combine XLOOKUP and LARGE or SMALL functions

preview_player
Показать описание

Most #excel users are familiar with VLOOKUP. Less are familiar with XLOOKUP.
Here's how you can combine XLOOKUP with LARGE and SMALL functions to find the name of a best- or worst-performing staff member or student.
Рекомендации по теме
Комментарии
Автор

what if 2 have the same money earned? xlookup will give me the same name twice. any solution for that?

Smirri