# Using 'Rank' in formulas?

**URL:** <https://community.fibery.io/t/using-rank-in-formulas/951>\
**Category:** Get Help\
**Created:** [September 3, 2020, 10:06am UTC](https://community.fibery.io/t/using-rank-in-formulas/951 "2020-09-03T10:06:01Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 3, 2020, 1:01pm UTC](https://community.fibery.io/t/using-rank-in-formulas/951/3 "2020-09-03T13:01:15Z")

</div>

Actually, the question was triggered by this other discussion:

> [@Filtering and getting first element](https://community.fibery.io/t/filtering-and-getting-first-element/948):
>
> 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](https://community.fibery.io/t/visual-indicator-of-priority-or-rank-heatmap/367) and wondered if a formula based on rank might provide the solution

---

_[View the full topic](https://community.fibery.io/t/using-rank-in-formulas/951)._