Forum Discussion
Help- Return text based on ranking with criteria
In the absence of the actual spreadsheet (the usefulness of images is limited; gives a sense of the data, but one can't do anything with it), I can suggest that you investigate the new Array Functions, in particular FILTER, SORT, SORTBY. They may well be able to accomplish what you describe.
I'd suggest you upload a working example--dummy the data if you want to protect confidentiality in some way--so that folks here don't have to create the example; that's a lot of data to work with.
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.
