'Using offset in finding the name for the largest value
I wish to find a way to find the three largest AuM values for each category and the Owner:
I found the n-th largest AuM per category using the Large-formula combined with IF:

Is there a way to find the name of the Owner? I tried using "Offset" but it doesnt work:

*edit: this is a test dataset. I do not wish to use Vlookup or Index+Match to find the corresponding name to the AuM value.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

