I understand how to find the top 5 /bottom 5 values using the large/small functions, but the question I have is:
How do I get associated fields. For example I attached a sample sheet with values (Fields: Ticker,TE,Sector,Return). How do I get the Ticker,Sector that the return is for.
I'd like to show all the associated fields that relate to the retun, but I can't find the solution on how to do that.
Any help would be appreciated.
Bookmarks