# Multiple ranked lists

**URL:** <https://connect.superhuman.com/t/multiple-ranked-lists/2660>\
**Category:** Ask the Community\
**Created:** [September 24, 2018, 12:16pm UTC](https://connect.superhuman.com/t/multiple-ranked-lists/2660 "2018-09-24T12:16:38Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\
**Post date:** [September 26, 2018, 11:44am UTC](https://connect.superhuman.com/t/multiple-ranked-lists/2660/3 "2018-09-26T11:44:13Z")

</div>

I’m guessing this is the setup you’re looking for:

[![CloudApp](https://global.discourse-cdn.com/coda1/original/3X/6/4/6466ad16233e3f292d910286601190e1087844b4.png "Image 2018-09-26 at 7.37.22 AM") ](https://cl.ly/geu8QQgb)

**[RowID]**  
Type: Number  
Formula: `RowId(thisRow)`

**[Rank]**  
Type: Number  
Formula: `Rank(RowID,thisTable.RowID,true)`

**[Rank in Category]**  
Type: Number  
Formula: `Filter(thisTable,Category=thisRow.Category).Rank.Find(thisRow.Rank)`

I know you mentioned 5 rows for each category, but I wanted to make sure it worked after deleting rows and with different numbers of rows in each category.

If you change the order of the rows, this will number them top to bottom each time, so the **[Rank in Category]** of the row can change if you move it’s position.

---

_[View the full topic](https://connect.superhuman.com/t/multiple-ranked-lists/2660)._