rank excel formula

[numfon_naka]

want to show ranking who is at how much
If the formula is in the app sheet, what should I do?

For example, who weighs the least? was ranked number 1

[Fernando_Lopez1]

Check this, maybe can help you:

https://www.appsheet.com/templates/Sample-App-to-demonstrate-how-to-find-the-INDEX-position-of-an-it...

[Swoopy]

Aternatively, if you're using Google Sheet as data source, you can create a column having RANK() therein.

But using ARRAYFORMULA(RANK(...)) is my recommendation because you can only place one formula at the first row (no copy&paste needed). By doing this, you can reduce calculation loads on your device, as a gift.