Hello all,
I'm trying to write a formula that will return the country names of the three highest weight allocations across time in a portfolio.
Column A has the country names, and columns B through BI contain the allocations to various countries over time.
I can get it using additional steps, as I have in K3:K5 with the help of column BJ, but I'd like to learn how to do it without creating extra columns that summarize the row data.
So in essence I want G3 to show "Japan" without the help of column BJ, if that makes sense. It would also be awesome to get the dates of the max values in H3:H5.
I've attached a sample file here to illustrate the issue.
Thanks in advance for any assistance.
-Mike
Bookmarks