Forum Discussion
Help- Return text based on ranking with criteria
mathetes - thank you for the reply. I have attached the data set.
I am looking to pull the fund in sheet 1 based on the criteria in raw data that the fund must be of a certain category( high equity) and the largest based on total assets.
Can you help?
I'll not be able to get to it until later on today--have some conflicting time obligations as the day starts.
If you want to give it a try, I'd suggest peeling off the "high equity" label from that column by using RIGHT.
Once that's done you could use SORT and FILTER to get the high equity funds only, sorted in descending order by asset value.
Others may come to your aide in the meantime.
This is one way to do it.
Patrick2788 - Thanks for the help. Would you have any idea how to do the rank function now, as I also need to rank the funds based on the segment criteria?
-So rank if "high equity" & etc?
