Using 'Rank' in formulas?

[Chr1sG]

Actually, the question was triggered by this other discussion:

Filtering and getting first element

Hi, I’m wondering if there is a way to filter and then select the first match in a formula. Something like: ItemPrices.filter(Price = ItemPrices.min(Price)).first().Vendor Alternatively, something like: ItemPrices.sort(Price).first().Vendor Thank you,

I figured that @Aram_Zadikian might be interested in returning the highest ranking vendor if there was more than one that had the cheapest price…

I also read this discussion page and wondered if a formula based on rank might provide the solution