Large, Index, and Match features within Excel

In this example I demonstrate how you can use Large, Index, and Match within Excel to pull the top 5 HR teams of all times. After getting the HR numbers, I then use the Index and Match features to find the team and year.

Тэги:

#excel #large #max #maxifs #index #match #map

Скачать видео