Forum Discussion
Help- Return text based on ranking with criteria
Hi There, My query is related to asset management data. I am trying to extract the text of the largest 10 funds based on the fund meeting a criteria eg "high equity" and the fund having the ...
Thanks mathetes. Only thing I am stuck with now is the numerical ranking. Any idea of a formulae that could return a numeric based on the original function
The formula, takes those records which meet the criteria ("high equity"), sorts the Assets in descending order then INDEX (w/ SEQUENCE) pulls out only 10 of those.
Conditional ranking is not as easy as it may seem. RANK cannot be array entered. Typically, the workaround is a SUMPRODUCT. I don't think we need to use that workaround if you've got access to dynamic arrays.